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 ONE Support launchpad (Login required).

Search for additional results

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