Qlik SAP Query Connector - DATA_TO_MEMORY_NOT_POSSIBLE

[Anonymous]

Hello Community,

I am new to the SAP Query Connector.  I have set up an account to be able to access SAP and run queries.  However, no matter what query I select, I get the following error:

Connector reply error: ErrorKey: DATA_TO_MEMORY_NOT_POSSIBLE, ErrorMessage:  Number:000

Table 'Table0' not found

Store * from [Table0] into ZMMHIERARCHY__ _ZMMFICO.QVD

Table not found

Drop Table Table0

I have done some research but I can't seem to find a solution.  Does anybody have experience with this connector/issue that would be willing to offer some guidance?

Thanks in advnce for any insights!

Jason

[Tomas_Sommergyll]

Hi Jason,

Below is the text from pdf document "Qlik Connector for SAP - Tips and Tricks" that can be found on the resources section next to the discussions list:

"Error ‘DATA_TO_MEMORY_NOT_POSSIBLE’

More authorization is needed. Compare SAP note 2212180. An SAP query might check authorization objects that are not part of the Qlik roles. In that case, they can be added to the role QTQVCACCESS or added to an additional customer-developed role that is assigned to the Qlik SAP user. A user with SAP_ALL authorization can be used to verify that it is an authorization problem."

Hope this helps,

Tomas