Database Administration (MOSC)

MOSC Banner

Problem IBM datastage with oracle

edited Oct 3, 2019 5:03AM in Database Administration (MOSC) 2 commentsAnswered

I have two server, in the first server is QA and this statements execute without problems

SELECT ID_SOLI,

MAX(ID_NOTI) AS ID_NOTI

FROM #$PRM_ORA_SCHE_OTS#.OTS_MAE_MENS

GROUP BY ID_SOLI

But in the second server, tis statements finished with error:

ora_OTS_MAE_MENS,0: The OCI function OCIStmtFetch2 returned status 1. Error code: 24347, Error message: ORA-24347: Warning of a NULL column in an aggregate func

ora_ODS_DEMANDA,0: The OCI function OCIStmtExecute returned status 1. Error code: 1400, Error message: ORA-01400: cannot insert NULL into ("ODSBISYS"."ODS_DEMANDA"."ID_EXPE").

Both server has same versions, same data source, same structurs and the user have same privilegies.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center