Stored Process Error in CI360 Flow Node — Code Executes Successfully, But Node Fails

onuroruc — Fri, 11 Jul 2025 07:25:07 GMT

Hi all,

I'm using a stored process (SP) in a SAS CI360 decision flow that updates data on Teradata successfully — the SQL logic executes correctly, no errors appear in the SAS log, and I can confirm the database is updated. However, the CI360 flow node returns an "Error" status, even though everything ran as expected.

🔍 Context:

The SP receives a segmentName prompt from CI360.

It connects to Teradata and runs an UPDATE (e.g., sets EMAIL_STATUS = 1).

%maspinit, %MAcount, and %MAstatus macros are used.

In some SPs, a work. dataset is created (work.Updated_Customers), others don't return any dataset.

The SP does not produce ODS output or use file _webout, unless manually added.

The SP is marked with the following properties:

✅ Stored Process Server Only

✅ Result Capabilities: Stream + Package are both checked.

💡 Interesting part:

The exact same logic works fine in another SP that updates PUSH_STATUS instead of EMAIL_STATUS. The only differences are:

Whether a segment is used in practice.

Whether a dataset or output is explicitly returned.

❓ My Questions:

What minimum output is required for a stored process to be considered "successful" by CI360?

Does CI360 require:

At least one SAS dataset in the work library?

A valid %MAstatus() file to be written under _STPWORK?

An ODS HTML or file _webout stream to be produced?

Is it OK for a stored process to return nothing (no dataset, no stream), or will CI360 always interpret that as an error?

🎯 Goal:
My stored process works fine in SAS and updates Teradata correctly, but CI360 seems to expect an output or a signal to consider the node successful. I’d like to understand what that expected behavior is so I can make all my SP nodes CI360-compliant.

Thanks a lot in advance!
(Viya environment + CI360 + Teradata)

Re: Stored Process Error in CI360 Flow Node — Code Executes Successfully, But Node Fails

LaniumFox — Fri, 31 Oct 2025 08:25:23 GMT

Hi,

Can you share the working STP code ?

As I am not been able to create one.
it would be very much helpful if you could share a sample code

Thanks

topic Stored Process Error in CI360 Flow Node — Code Executes Successfully, But Node Fails in SAS 360 Match

Stored Process Error in CI360 Flow Node — Code Executes Successfully, But Node Fails

Re: Stored Process Error in CI360 Flow Node — Code Executes Successfully, But Node Fails