Troubleshooting
Problem
OS: AS/400 DB/2 Using Client Access ODBC Driver to attach to AS/400 database. Impromptu Client connects successfully but IWR reports fail with the following error DMS-E-SECURITY, an operation was attempted without appropriate permissions during operation 'prepare request'. [IBM][CLIENT ACCESS EXPRESS ODBC DRIVER(32-BIT)][DB2/400 SQL]sql7973 ¿ SQL create package for IMPADMINBA in QGPL has failed
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu Web Reports","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF025","label":"Platform Independent"}],"Version":"Cognos ReportNet 1.1MR2;Cognos ReportNet 1.1MR3;Impromptu 7.3;Impromptu Web Reports 7.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu Web Reports","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
121506
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21349283