Hi Experts!   We have a Data Query code file in SAS Intelligent Decisioning that writes to an Oracle Database. One string variable is being written to a variable with CLOB data type in Oracle, since its values will go beyond the 4000 limit of VARCHAR.   It works when we do the insert statement via SAS Studio, but testing the code file from the SCORING tab of a Decision Flow in SAS ID deems that it's unable to write to the table. Same thing happens when we publish to MAS - it's also unable to write to the table.   Is there any CAS / MAS related limitation to writing to a CLOB variable in Oracle? We encounter the same problem for writing to variables in Oracle with LONG data type. Attached is a portion of the logs for reference.   Hoping to get some guidance regarding this error   Thank you!!! ... View more

Hi Experts!   We have a Data Query code file in SAS Intelligent Decisioning that writes to an Oracle Database. One string variable is being written to a variable with CLOB data type in Oracle, since its values will go beyond the 4000 limit of VARCHAR.   It works when we do the insert statement via SAS Studio, but testing the code file from the SCORING tab of a Decision Flow in SAS ID deems that it's unable to write to the table. Same thing happens when we publish to MAS - it's also unable to write to the table.   Is there any CAS / MAS related limitation to writing to a CLOB variable in Oracle? We encounter the same problem for writing to variables in Oracle with LONG data type. Attached is a portion of the logs for reference.   Hoping to get some guidance regarding this error   Thank you!!!     ... View more

Hi Experts! We're currently working with SAS Intelligent Decisioning running in LTS 2022.1, and we are having challenges with publishing Decisions in MAS. Sometimes, when we re-publish a decision flow - publishing does not end. At the onset, increasing the RAM helped resolve the issue. But then we experience the same problem again (While we maintained the same increased RAM). I say "Sometimes" because re-publishing will work for sometime for a specific decision_flow name, until such time we cannot publish it again and we implement the work-around of publishing it under a new name.   We have been looking at MAS logs, also sending to Technical Support. These are the last two lines of the log as reference recently. So far we've only seen the status of publishing to be stuck in PENDING: moduleId=DECISIONFLOWMAIN5_5, state=PENDING, errors=[], toString()=AbstractModifiableResource[createdBy=dev_user, creationTimeStamp=2023-02-15 01:52:52.214, modifiedBy=dev_user, modifiedTimeStamp=2023-02-15 01:52:52.214 and another one on ACCESS_TOKEN_FAILURE which we're unsure if related since the team has not been experiencing any access token related error during this time : [ACCESS_TOKEN_FAILURE] Could not obtain access token.\nerror=\"access_denied\", error_description=\"Access token denied We are trying to understand what is the key root cause. Attached are the last few lines of the log for reference.   1) Has anybody experienced the same, and how have you addressed this problem? 2) Is there any "un-publish" function in any SAS CLI/ APIs, or anywhere in the GUI (that we are supposed to use before re-publishing the same flow? So far we have only seen the APIs for listing the published flows and deleting published flows, and none from the SAS Viya Application. 3) Is publishing really expected to be that RAM intensive? The more complex the decision flow, the higher RAM resources is taken during publishing - even before execution? 4) What process actually happens as we publish the decision flow to MAS? Does it somehow execute the script/logic such that it tries to issue an actual connection to the databases and APIs that are being called by the code files within the Decision Flow? 5) What other elements/components, that may influence the publishing process, can you recommend for us to look at?   Thank you!!!   ... View more