in Problem Notes for SAS®9 - 65900: Registering an Oracle table to the metadata might fail and generate an error By feedproxy.google.com Published On :: Fri, 8 May 2020 09:38:11 EST When you register an Oracle table to the metadata, it might fail and generate an error similar to the following: "ERROR: An exception has been encountered...ERROR: Read Access Violation METALIB..." Full Article METADATASRV+SAS+Metadata+Server
in Problem Notes for SAS®9 - 35066: When a bulk-loading process fails with "SQL*Loader 2026" error, error message appears as a warning in the SAS log By feedproxy.google.com Published On :: Thu, 7 May 2020 17:15:19 EST If a bulk-loading process fails when you use SAS with SAS/ACCESS Interface to Oracle, you will receive the warning: "WARNING: All or some rows were rejected/discarded.: The actual error is "SQL*Loader-2026: The load was aborted because SQL Full Article ORACLE+SAS/ACCESS+Interface+to+Oracle
in Problem Notes for SAS®9 - 65834: PROC METADATA returns various errors when the input contains certain multi-byte characters By feedproxy.google.com Published On :: Thu, 7 May 2020 17:12:13 EST The METADATA procedure might return an error similar to one of the following: ERROR: Missing root element definition. Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 60332: A SAS 9.4 installation in Update mode notifies you about unwritable files in the "SASHome\SASWebApplicationServer" directory By feedproxy.google.com Published On :: Wed, 6 May 2020 14:49:04 EST When you run SAS Deployment Wizard to install or update SAS 9.4 software, the file system is examined. If any files that the wizard needs to delete are found to be locked, they are reported as unwritable f Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65918: SAS Workflow Services fails to respond after a com.sas.workflow.engine.policy.PolicyExecutionException error occurs for a workflow instance By feedproxy.google.com Published On :: Wed, 6 May 2020 13:42:50 EST When the problem occurs, you are unable to perform any workflow actions in a SAS solution that uses SAS Workflow Services. Full Article WEBINFPLTFM+SAS+Web+Infrastructure+Platf
in Problem Notes for SAS®9 - 65929: A grid-enabled sign-on to SAS 9.4M6 (TS1M6) fails with errors, including "Remote signon canceled" By feedproxy.google.com Published On :: Wed, 6 May 2020 13:02:23 EST A sign-on to a grid-enabled environment fails while it is trying to communicate with the client host. The following errors then appear in the SAS log: < Full Article GRIDMGR+SAS+Grid+Manager
in Problem Notes for SAS®9 - 64285: The SCD Type 2 Loader transformation in SAS Data Integration Studio generates "ERROR 22-322: Syntax error, expecting one of the following:..." By feedproxy.google.com Published On :: Wed, 6 May 2020 12:38:17 EST If your business key column is a name literal, like " business key "n, a syntax error occurs when that variable name does not follow standard SAS naming conventions. Full Article DATABUILDER+SAS+Data+Integration+Studio
in Problem Notes for SAS®9 - 64459: A SAS Data Integration Studio job receives an error that states "The name '; index_name '; has the wrong number of qualifiers" By feedproxy.google.com Published On :: Wed, 6 May 2020 12:37:37 EST An error occurs because of an incorrectly generated CREATE INDEX clause in an SQL query that is sent to DB2 when the DB2 schema value is SESSION . The error message says "The name '; index_name '; has the wrong number of qualifie Full Article DATABUILDER+SAS+Data+Integration+Studio
in Problem Notes for SAS®9 - 65908: The IMPORT procedure contains a stack-corruption vulnerability By feedproxy.google.com Published On :: Wed, 6 May 2020 10:55:40 EST Severity: Medium Description: PROC IMPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances (with use of the DBM Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65906: The EXPORT procedure contains a stack-corruption vulnerability By feedproxy.google.com Published On :: Wed, 6 May 2020 10:55:01 EST Severity: Medium Description: PROC EXPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances, the use of PROC EXP Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65922: Trying to read a Google BigQuery table that contains a variable defined as an array might result in a panic error and SAS shutting down By feedproxy.google.com Published On :: Wed, 6 May 2020 10:30:19 EST Trying to read a Google BigQuery table that contains a variable that is defined as an array of records might result in an error and cause SAS to shut down. This issue occurs when one of the variables contained in Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
in Problem Notes for SAS®9 - 65295: The order of columns is not maintained when you select columns for output in the Business Rules transformation By feedproxy.google.com Published On :: Wed, 6 May 2020 10:01:07 EST In SAS Data Integration Studio, the columns that you select to include in the target table in a Business Rules transformation appear in the Selected columns area in a random order. Th Full Article DATABUILDER+SAS+Data+Integration+Studio
in Problem Notes for SAS®9 - 65916: Accessing a Google BigQuery table without including the SCHEMA= option in the LIBNAME statement might result in an error By feedproxy.google.com Published On :: Wed, 6 May 2020 09:41:22 EST When you issue a LIBNAME statement for a Google BigQuery database without including the SCHEMA= option, all tables in the project are shown when the libref is expanded. However, if you try to acces Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
in Problem Notes for SAS®9 - 65031: Grid options set mappings are returned based on which option set is the first in the metadata search chain By feedproxy.google.com Published On :: Tue, 5 May 2020 15:04:46 EST When users are defined in multiple groups associated with grid options set mappings, the first grid option set that is returned by the metadata search chain takes precedence. Only one grid options set mapping is used Full Article GRIDMGR+SAS+Grid+Manager
in Problem Notes for SAS®9 - 34294: A missing discrete dependent variable in the selection model together with a OUTPUT statement might cause an Access Violation error By feedproxy.google.com Published On :: Tue, 5 May 2020 13:04:13 EST If the following conditions are met in PROC QLIM: the SELECT option and DISCRETE option are specified in the same MODEL statement or ENDOGENOUS statement the same dependent variable with S Full Article ETS+SAS/ETS
in Problem Notes for SAS®9 - 65927: The Copy Files task in SAS Enterprise Guide 8.2 fails with the message "ERROR: Target folder does not exist or cannot be accessed" By feedproxy.google.com Published On :: Tue, 5 May 2020 09:59:15 EST When you run the Copy Files task in SAS Enterprise Guide and there is no connection to a SAS server, it fails with the following error: "ERROR: Target folder does not exist or cannot be accessed." Full Article EGUIDE+SAS+Enterprise+Guide
in Problem Notes for SAS®9 - 65903: You see a "java.lang.IllegalArgumentException" error in the log file when you use the IFRS9_Cycle workflow template in SAS Solution for IFRS 9 By feedproxy.google.com Published On :: Fri, 1 May 2020 18:01:29 EST The problem occurs on a content release on the SAS Risk Governance Framework. Full Article RGPBNDL+SAS+Risk+Governance+Framework
in Problem Notes for SAS®9 - 65872: You see a "java.lang.IllegalArgumentException" error in the log file when you use the CECL_Cycle workflow template in SAS Solution for CECL By feedproxy.google.com Published On :: Fri, 1 May 2020 16:53:01 EST The problem occurs on a content release on the SAS Risk Governance Framework. Full Article RGPBNDL+SAS+Risk+Governance+Framework
in Problem Notes for SAS®9 - 65904: SAS Federation Server stops responding when you run queries against X_OBJECT_PRIVILEGES in SYSCAT and the queries run for hours By feedproxy.google.com Published On :: Fri, 1 May 2020 14:48:24 EST The select * from "SYSCAT"."SYSCAT"."X_EFFECTIVE_OBJECT_PRIVILEGES" query runs for hours. In this scenario, SAS Federation Server stops responding, making it unavailable for use. Restarting SAS Federation Server solves t Full Article DFFEDSVR+SAS+Federation+Server
in Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause By feedproxy.google.com Published On :: Fri, 1 May 2020 14:43:59 EST When you query an Oracle table and use the LIMIT clause using either SAS Federation Server or FedSQL, a row limit is not passed to the database. In this scenario, a Full Article DFFEDSVR+SAS+Federation+Server
in Problem Notes for SAS®9 - 65914: You see the error "Driver does not support this optional feature" after trying to insert or append data to a Databricks table By feedproxy.google.com Published On :: Fri, 1 May 2020 14:23:57 EST You can create create a Databricks table by using PROC SQL, but you cannot insert data into the table. PROC APPEND cannot create a new table or append data to an existing table. Full Article JDBCBNDL+SAS/ACCESS+Interface+to+JDBC
in Problem Notes for SAS®9 - 65574: Decimal values are rounded after they are inserted into a new Databricks table via SAS/ACCESS Interface to JDBC By feedproxy.google.com Published On :: Fri, 1 May 2020 13:17:00 EST A DATA step and PROC SQL can round numeric values while creating and loading data into a new Databricks table via JDBC. Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65886: Trying to bulk load data into a Google BigQuery database might result in an error By feedproxy.google.com Published On :: Fri, 1 May 2020 10:00:17 EST When you bulk load data into a Google BigQuery database, you might encounter this error: "Error while reading data, error message: CSV table encountered too many errors, giving up...Error detected while parsing row starting at position: 0...Data Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
in Problem Notes for SAS®9 - 65898: A misleading SASTRACE message appears in the log when you insert a row into an Oracle table using SAS/ACCESS Interface to Oracle with DBIDIRECTEXEC By feedproxy.google.com Published On :: Thu, 30 Apr 2020 13:52:24 EST When you add one row to an Oracle table using DBIDIRECTEXEC, you see the following misleading trace message: "ORACLE: 4294967296 rows inserted/updated/deleted." You should see something similar to the following: "ORACLE: 1 rows inserte Full Article ORACLE+SAS/ACCESS+Interface+to+Oracle
in Problem Notes for SAS®9 - 64980: The PRINT procedure contains a buffer-overrun vulnerability By feedproxy.google.com Published On :: Thu, 30 Apr 2020 10:19:20 EST Severity: Medium Description: PROC PRINT might fail with a buffer overrun when you submit it in conjunction with certain malformed SAS statements. Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 64550: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter By feedproxy.google.com Published On :: Thu, 30 Apr 2020 10:18:27 EST Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact: Full Article CASEMGMTOFR+SAS+Enterprise+Case+Manageme
in Problem Notes for SAS®9 - 65893: Custom sorts are sorted incorrectly when they are used in a hierarchy in SAS Visual Analytics Designer By feedproxy.google.com Published On :: Wed, 29 Apr 2020 12:29:05 EST A custom sort might be sorted incorrectly when the data item is used in a custom category, which is then used in a hierarchy. The issue can occur in the following scenario: Full Article VISANLYTBNDL+SAS+Visual+Analytics
in Problem Notes for SAS®9 - 65844: STRESS task fails with "Fatal error in PMPI_Bcast: Other MPI error, error stack: PMPI_Bcast(1478)" By feedproxy.google.com Published On :: Tue, 28 Apr 2020 13:35:57 EST In SAS High-Performance Risk, a STRESS task might fail with a message like the following in the SAS log while the compute server is sending the ScenarioCF/Value data to the HPRisk Engine: Full Article HPRISKOFR+SAS+High-Performance+Risk
in Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows By feedproxy.google.com Published On :: Tue, 28 Apr 2020 12:39:06 EST A set of PROC SQL queries that create a view, contain a constant column, contain a computed column, and a create a table do not generate a unique set of rows in the table that is created. Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65597: An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results By feedproxy.google.com Published On :: Tue, 28 Apr 2020 12:37:41 EST An issue occurs when code contains a complex SQL procedure query with a WHERE clause that contains multiple subselects. Incorrect results might be returned. Click the Hot Fix tab in this note to Full Article BASE+Base+SAS
in Problem Notes for SAS®9 - 65572: The length of a string variable might be longer than specified with the MAX_CHAR_LEN= option By feedproxy.google.com Published On :: Tue, 28 Apr 2020 08:30:03 EST When you read in a BigQuery table, the length of string variables might be longer than the length specified with the MAX_CHAR_LEN= option when running your SAS software with UTF-8. By Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
in Problem Notes for SAS®9 - 65856: The process of updating a lookup table in SAS Business Rules Manager (running in UNIX operating environments) does not work properly By feedproxy.google.com Published On :: Mon, 27 Apr 2020 13:37:52 EST Under UNIX, the process of updating a lookup table in SAS Business Rules Manager does not work properly. The problem occurs when you perform these steps: Open a lookup table. Cl Full Article BRLSTBNDL+SAS+Business+Rules+Manager
in Problem Notes for SAS®9 - 65868: Saving a report distribution in SAS Visual Analytics Designer fails with "The name is invalid" By feedproxy.google.com Published On :: Fri, 24 Apr 2020 12:03:57 EST When you attempt to save a report distribution in SAS Visual Analytics Designer, you might see the error shown in the following display: imgalt="" src="{fusion_65868_1_distributionerror.png}" /> Full Article VISANLYTBNDL+SAS+Visual+Analytics
in Here's your guide to Rays Spring Training By mlb.mlb.com Published On :: Wed, 6 Feb 2019 14:04:04 EDT Baseball season is now on the clock and the Rays are looking to get back to the postseason for the first time since 2014. That quest will begin next week as Spring Training is finally upon us. Here's a primer to get you informed on all you need to know this spring. Full Article
in Inbox: How will potential new rule affect Rays? By mlb.mlb.com Published On :: Thu, 7 Feb 2019 11:50:31 EDT Rays beat reporter Juan Toribio answers fans' questions. Full Article
in Rays' 2019 mantra: Prepare to win from within By mlb.mlb.com Published On :: Fri, 8 Feb 2019 16:05:02 EDT Over the past couple seasons, the Rays have preached patience as the organization provided time for the top prospects to make it up to the Majors. Now, the focus has been primarily in remaining flexible and keeping positions open for the young talent arriving from the Minors. Full Article
in Bulked-up Duffy looks to sustain at plate in '19 By mlb.mlb.com Published On :: Sat, 9 Feb 2019 17:43:24 EDT As Matt Duffy entered the offseason, he knew that he needed to add strength in order to hold up over the course of a 162-game season. The 28-year old has been at the Rays' Spring Training facility in Port Charlotte, Fla., for about a week, and he believes his improved shape will help the team fight for a playoff spot in 2019. Full Article
in Predicting Rays' Opening Day roster By mlb.mlb.com Published On :: Sun, 10 Feb 2019 13:19:32 EDT Here's an early look at how the Rays' 25-man roster could shape up on Opening Day. Full Article
in Rays two-way prospect McKay to DH only in '19 By mlb.mlb.com Published On :: Mon, 11 Feb 2019 11:45:51 EDT Brendan McKay is still going to be a two-way player, but the Rays are planning to narrow his focus on the hitting side by keeping him to designated hitter-only duties, a source confirmed to MLB.com's Juan Toribio on Monday. Full Article
in A little rain can't keep eager Rays from field By mlb.mlb.com Published On :: Wed, 13 Feb 2019 15:17:29 EDT A rainy morning didn't stop the Rays' pitchers and catchers from officially taking the field Wednesday. "Other than the pitchers getting out there and getting in their legs a little bit and running some of the more casual [pitchers' fielding practice drills], everything is fine," manager Kevin Cash said. Full Article
in Snell not feeling pressure in '19 after Cy win By mlb.mlb.com Published On :: Wed, 13 Feb 2019 11:52:53 EDT After winning the 2018 American League Cy Young Award, Blake Snell said he doesn't feel "any pressure" in '19. Full Article
in Spring brings vet leaders for blossoming Rays By mlb.mlb.com Published On :: Wed, 13 Feb 2019 13:12:50 EDT When Tyler Glasnow heard the news that the Rays were signing Charlie Morton, he couldn't help but get even more excited for the 2019 season. Full Article
in Pagan working to develop off-speed pitches By mlb.mlb.com Published On :: Thu, 14 Feb 2019 16:43:16 EDT As Emilio Pagan enters his first Spring Training with the Rays, he's looking to prove that he can perform well against hitters on either side of the plate. Full Article
in Prospect Poche making strong first impression By mlb.mlb.com Published On :: Thu, 14 Feb 2019 12:51:58 EDT Colin Poche's fastball won't light up the radar gun, but it proved to be one of the most effective pitches in the Minors last season. Full Article
in Faria enters camp fighting for bullpen spot By mlb.mlb.com Published On :: Fri, 15 Feb 2019 13:24:43 EDT After a disappointing 2018 season, Jake Faria is looking to show that last season isn't reflective of the type of pitcher he is. Full Article
in Glasnow working to quicken delivery By mlb.mlb.com Published On :: Sat, 16 Feb 2019 15:35:57 EDT Tyler Glasnow is hoping to build off a positive 2018, but his delivery is going to look a little different this season. Full Article
in Kiermaier eyeing 'huge rebound year' in 2019 By mlb.mlb.com Published On :: Sat, 16 Feb 2019 11:43:28 EDT Kevin Kiermaier has always played with a chip on his shoulder, but he admits that there's some extra motivation heading into Spring Training after a frustrating 2018 season. Full Article
in The Rays' Spring Training battle to watch By mlb.mlb.com Published On :: Mon, 18 Feb 2019 18:20:16 EDT The next five weeks will see lots of shuffling on Major League rosters. Here are the most intriguing positional battles on each of the 30 MLB clubs. Full Article
in Here are 10 Rays players to watch this spring By mlb.mlb.com Published On :: Sun, 17 Feb 2019 13:46:36 EDT While most of the attention will fall on the players who are expected to make the Opening Day roster, manager Kevin Cash and the rest of the organization will be keeping a close eye on some of the players that could find their way to the big leagues at some point within the next year. Full Article
in Cash reminder: Stay focused on the now By mlb.mlb.com Published On :: Mon, 18 Feb 2019 19:40:59 EDT All 66 players on the Rays' Spring Training roster took the field Monday as Tampa Bay went through its first full-squad workout. Full Article