I am working on a set of custom functions that use repository tables. So far I created a datastore to specifically access these tables. However, I know there is an internal (hidden) datastore, named CD_DS_d0cafae2, that always points to the repository.
Is the use of this datastore supported? I found some posts of Werner that suggest it is, but it is nowhere documented.
On my Windows/Oracle sandbox system this works fine. However I need to use the built-in sql() function and specify my own queries, because the lookup_ext function specifies the table owner rendering my functions not portable across multiple repositories.
On Linux/HANA it works, but gives me this error:
ODBC call <SQLDriverConnect> to connect database <> failed with error: <ODBC call <SQLDriverConnect> to connect database <>
failed with error: <[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[-1] Kerberos
error. Major: "Miscellaneous failure [851968]", minor: " [100001]" (server:port))>. Use the ODBCDriverSelector (Windows) or
DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still
exists after selecting the correct version of the driver, notify Customer Support.>. Use the ODBCDriverSelector (Windows) or
DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still
exists after selecting the correct version of the driver, notify Customer Support.My job only contains one script with this one statement just to test it:
print( sql( 'CD_DS_d0cafae2', 'select min(parent_obj) from alvw_parent_child') );
To my surprise the internal jobs that calculate usage dependencies and column mappings do not give this error, although they use the same internal datastore?
Can anybody shed some light on this? What’s going on?
This is on a 14.2.7 system running HANA 1.0 SP12.
lamanp 
(BOB member since 2008-09-02)
(BOB member since 2007-09-12)