SAP Knowledge Base Article - Preview

2504535 - ErrID: 8192 when executing INSERT..LOCATION from a procedure

Symptom

The following error is reported when executing "Insert..Location" coded into a Stored Procedure:

=====

I. 07/06 11:54:17. 0000000018 Txn 1884876 0 1884876
I. 07/06 11:54:17. 0000000018 Exception Thrown from hqmlib/hqm_con.cxx:199,
Err# 1, tid 6 origtid 6I. 07/06 11:54:17. 0000000018 O/S Err#: 0, ErrID: 8192 (hqm_exception); SQLCode: -1003002, SQLState: 'QHA02', Severity: 14

======

This problem does not occur if we execute the command outside from stored procedure.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

ErrID: 8192 SQLCode: -1003002, SQLState: 'QHA02' insert location stored procedure inside SQL SECURITY INVOKER DEFINER authentication create statement , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.