t

Problem Notes for SAS®9 - 65938: Incorrect values might be written to Hadoop for columns defined with the BIGINT data type

Large numeric values consisting of 16 digits in SAS might be incorrect when written to Hadoop for columns defined with the BIGINT data type.  This problem was introduced in SAS 9




t

Problem Notes for SAS®9 - 65900: Registering an Oracle table to the metadata might fail and generate an error

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..."




t

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

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




t

Problem Notes for SAS®9 - 65834: PROC METADATA returns various errors when the input contains certain multi-byte characters

The METADATA procedure might return an error similar to one of the following:

  • ERROR: Missing root element definition.
  • Full Article


  • t

    Problem Notes for SAS®9 - 65899: "ERROR: ORACLE disconnect error: ORA-03135" occurs when SAS disconnects from the Oracle database server

    When you run 32-bit SAS on Windows and disconnect from the Oracle database server, you might see the error: "ERROR: ORACLE disconnect error: ORA-03135: connection lost contact."




    t

    Problem Notes for SAS®9 - 60332: A SAS 9.4 installation in Update mode notifies you about unwritable files in the "SASHome\SASWebApplicationServer" directory

    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




    t

    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

    When the problem occurs, you are unable to perform any workflow actions in a SAS solution that uses SAS Workflow Services.




    t

    Problem Notes for SAS®9 - 65929: A grid-enabled sign-on to SAS 9.4M6 (TS1M6) fails with errors, including "Remote signon … canceled"

    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:


    t

    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:..."

    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.




    t

    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"

    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




    t

    Problem Notes for SAS®9 - 65908: The IMPORT procedure contains a stack-corruption vulnerability

    Severity: Medium Description: PROC IMPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances (with use of the DBM




    t

    Problem Notes for SAS®9 - 65906: The EXPORT procedure contains a stack-corruption vulnerability

    Severity: Medium Description: PROC EXPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances, the use of PROC EXP




    t

    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

    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




    t

    Problem Notes for SAS®9 - 65295: The order of columns is not maintained when you select columns for output in the Business Rules transformation

    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




    t

    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

    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




    t

    Problem Notes for SAS®9 - 65935: The UNICODE function does not support Numeric Character Representation (NCR) for a surrogate pair

    Using the NCR form of a surrogate pair as an input string to the UNICODE function does not convert the string to the appropriate display character.




    t

    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

    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




    t

    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

    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




    t

    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"

    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."




    t

    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

    The problem occurs on a content release on the SAS Risk Governance Framework.




    t

    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

    The problem occurs on a content release on the SAS Risk Governance Framework.




    t

    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

    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




    t

    Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause

    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



    t

    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

    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.




    t

    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

    A DATA step and PROC SQL can round numeric values while creating and loading data into a new Databricks table via JDBC.




    t

    Problem Notes for SAS®9 - 65886: Trying to bulk load data into a Google BigQuery database might result in an error

    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




    t

    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

    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




    t

    Problem Notes for SAS®9 - 65909: SAS Visual Analytics Designer 7.5 responds slowly when you edit large or complex reports

    If your SAS Visual Analytics report contains many sections and objects, you might encounter performance problems when you are editing the report.   A hot fix is planned for this issue.




    t

    Problem Notes for SAS®9 - 64980: The PRINT procedure contains a buffer-overrun vulnerability

    Severity: Medium Description: PROC PRINT might fail with a buffer overrun when you submit it in conjunction with certain malformed SAS statements.



    t

    Problem Notes for SAS®9 - 64550: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter

    Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact:




    t

    Problem Notes for SAS®9 - 65893: Custom sorts are sorted incorrectly when they are used in a hierarchy in SAS Visual Analytics Designer

    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:




    t

    Problem Notes for SAS®9 - 65844: STRESS task fails with "Fatal error in PMPI_Bcast: Other MPI error, error stack: PMPI_Bcast(1478)"

    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:



    t

    Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows

    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.




    t

    Problem Notes for SAS®9 - 65597: An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results

    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




    t

    Problem Notes for SAS®9 - 65572: The length of a string variable might be longer than specified with the MAX_CHAR_LEN= option

    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




    t

    Problem Notes for SAS®9 - 65883: SAS Workflow Studio returns a "cannot load" error when you try to open the CECL_Cycle_AFS workflow template for SAS Solution for CECL

    You might see the following error in SAS Workflow Studio when you try to open the CECL_Cycle_AFS workflow template that is shipped with SAS Solution for CECL:



    t

    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

    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




    t

    Problem Notes for SAS®9 - 65869: SAS Visual Data Builder does not enable you to schedule with multiple time-event triggers

    SAS Visual Data Builder might not enable you to create multiple time-event triggers. The + button to add another trigger is not available to select, as shown in the following display: imgalt="" src="{fusion_658




    t

    Problem Notes for SAS®9 - 65868: Saving a report distribution in SAS Visual Analytics Designer fails with "The name is invalid"

    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}" />



    t

    Around the Horn: Pham, Choi aim to boost Rays

    Over the past couple of weeks leading up to Spring Training, MLB.com went around the horn to examine each area of the Rays' 2019 roster. The final installment focuses on Tampa Bay's outfield and designated hitters.




    t

    Here's your guide to Rays Spring Training

    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.




    t

    Inbox: How will potential new rule affect Rays?

    Rays beat reporter Juan Toribio answers fans' questions.




    t

    Rays' 2019 mantra: Prepare to win from within

    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.




    t

    Bulked-up Duffy looks to sustain at plate in '19

    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.




    t

    Predicting Rays' Opening Day roster

    Here's an early look at how the Rays' 25-man roster could shape up on Opening Day.




    t

    Uniform patch to mark 150 years of pro baseball

    All 30 Major League teams will wear special "MLB 150" patches on their uniforms for the entire 2019 season in honor of the 150th anniversary of the 1869 Cincinnati Red Stockings, the first openly all-salaried professional baseball team.




    t

    30 low-key acquisitions who could pay off big

    Fans and analysts spend the entire offseason speculating where the top free agents could go, but sometimes an under-the-radar pickup can end up making a world of difference. As positional competitions begin to heat up at Spring Training camps this month, MLB.com's beat writers were asked to identify one potentially overlooked acquisition for each of the 30 clubs. Here's who they came up with.




    t

    Rays two-way prospect McKay to DH only in '19

    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.




    t

    Morton believes Rays can make postseason

    After a pair of seasons -- and a World Series title -- with the Astros, Rays pitcher Charlie Morton is confident that his new team has what in takes to make a postseason run in 2019.




    t

    A little rain can't keep eager Rays from field

    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.