Generating EEM security certificates via autosys_secure results in Sybase errors.

Document ID : KB000006170
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

 

Generating EEM security certificates via autosys_secure results in Sybase errors.

Error:

CAUAJM_E_18000 Database function call <ct_send_data> failed in <updateBlobData> with return code: 0
CAUAJM_E_18015 Client message: Message number: layer (4), Origin (2), text (ct_send_data(): protocol specific layer: internal Client Library error: There is an internal tds layer error. An error was returned from the server while processing an internal tds stream.), SEVERITY = (6), NUMBER = (50)
CAUAJM_E_18016 Server: WAAE1136SP5
CAUAJM_E_18018 Server message: Message number(7130), Severity(16), State(1), Line(1), Message String: WRITETEXT with no log is not valid at this time.  Database AEDB must first be configured for this.

CAUAJM_E_18012 Event Server: <WAAE1136SP5:AEDB>  Failed Stored Procedure: <EXEC ujo_put_keyed_blob @blob_id <<[@value=ed4f7f20],'SAFECERT'>>>
CAUAJM_E_18007 Failed to update the Blob Global Variable.
CAUAJM_E_18006 next_row call failed for IO Descriptor in Blob implementation.
CAUAJM_E_18000 Database function call <ct_send_data> failed in <updateBlobData> with return code: 0
CAUAJM_E_18015 Client message: Message number: layer (4), Origin (2), text (ct_send_data(): protocol specific layer: internal Client Library error: There is an internal tds layer error. An error was returned from the server while processing an internal tds stream.), SEVERITY = (6), NUMBER = (50)
CAUAJM_E_18016 Server: WAAE1136SP5
CAUAJM_E_18018 Server message: Message number(7130), Severity(16), State(1), Line(1), Message String: WRITETEXT with no log is not valid at this time.  Database AEDB must first be configured for this.

...

...

...
CAUAJM_E_10163 Exhausted maximum number of query retries.
CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:

CAUAJM_E_10487 An error occurred uploading the certificate file to the database.

CAUAJM_E_60199 Unable to generate the CA EEM certificate. See previous error messages for details.
CAUAJM_W_60190 The CA EEM server location remains unchanged.

 

Note: Sybase ASE server name "WAAE1136SP5" and the database name "AEDB" in the aforementioned error snip could be different in your environment.

Environment:
CA Workload Automation AE 11.3+, 11.3.5.x, 11.3.6.x on all supported OS platforms with Sybase ASE database(s).
Cause:

 

The aforementioned Sybase error while generating EEM (external security) certificates is a result of the Sybase ASE database option "select into/bulkcopy/pllsort" not being enabled for the CA WAAE Database.

Resolution:

To address this problem, follow steps below:

 

1. Check if the WAAE database in the Sybase ASE server has been setup with the "select into/bulkcopy/pllsort" option. You can use the sp_helpdb stored procedure to within the isql command line, like so:

sh-4.2$ isql -U sa -P <password> -S WAAE1136SP5 -w 200 -s"|"
1> sp_helpdb
2> go

Example:

sybase_sp_helpdb.png

 

2. If the "select into/bulkcopy/pllsort" option does not appear under the status column of the sp_helpdb output, then enable the db option using the following isql commands:

sh-4.2$ isql -U sa -P <password> -S WAAE1136SP5
1> use AEDB
2> go
1> master..sp_dboption AEDB, "select into", true
2> go
Database option 'select into/bulkcopy/pllsort' turned ON for database 'AEDB'.
Running CHECKPOINT on database 'AEDB' for option 'select into/bulkcopy/pllsort' to take effect.
(return status = 0)
1>

Note: By default, the WAAE database on Sybase ASE is setup with the following DB options during installation. Disabling these options may result in unexpected WAAE behavior.

  • select into/bulkcopy/pllsort
  • trunc log on chkpt
  • abort tran on log full
Additional Information: