000021836 - Sd_DynamicSelect fails with more than 9 columns in the result

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000021836
Applies ToRSA ACE/Server 5.2
Sun Solaris 2.8
IssueSd_DynamicSelect fails with more than 9 columns in the result
The ACE Administration API has a function call of:

      int Sd_DynamicSelect(char *fileOrPoolName, int iFormat, int iHeader, int iNumRecors, int iParseData, char *szColumnAlias, char * szExtender, char *szSQL1, char *szSQL2, char *szSQL3, char *szSQL4, char *msgBuf,int bufSize)

This allows user to run SQL queries against the ACE database, and the resulting report is saved to the file name provided through 'fileOrPoolName' parameters. However, on Solaris systems, if the SQL query result contains more than nine columns, the function call will fail with the return code 2182, and the message buffer "Error in opening file".
ResolutionThis issue is resolved in a hot fix. Contact RSA Security Customer Support and reference hot fix tst43065.
Legacy Article IDa25207

Attachments

    Outcomes