Trigger stored procedure issue

dataservices job design
1

Hi folks, we are having issue in triggering SP.

In SSMS if gives warning but execute successfully.
Warning: Null value is eliminated by an aggregate or other SET operation.
0

In DS 4.2SP3 Win OS repo on sql server.
PRINTS ‘NULL’ but job wont fail or terminate.

But In DS 4.2SP6 Linux OS repo on sybase.
Job terminates and prints -
ODBC data source <> error message for operation : <[SAP BusinessObjects][ODBC 20101 driver][Microsoft SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation. [SAP BusinessObjects][ODBC 20101 driver][Microsoft SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.>.

Need help to fix it…does anything experienced the same issue?

Thanks

n78882 :us: (BOB member since 2010-09-17)

2

That could be a DS issue, but looks more like a driver issue. Either the ODBC driver is reporting the “warning” as an error or the job server is interpreting that “warning” as an error.

A few things to try to fix:

  1. Try a newer or older ODBC driver on the Linux box.
  2. Figure out how to remove the warning (some ideas at http://stackoverflow.com/questions/11384292/warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation-in-aqua)
  3. Upgrade to SP8 and see if that fixes it.
  4. Put in a ticket with SAP to resolve.
  • E

eepjr24 :us: (BOB member since 2005-09-16)