All Forums Extensibility
Sayandeep 7 posts Joined 04/12
09 Sep 2014
urgent : xml conversion

have create the below proc to invoke as_shred_batch ,
REPLACE PROCEDURE MY_SHREDBATCH_SP
(IN sourceDataQuery varchar(6000),IN annotatedSchemaID varchar(32),OUT resultCode varchar(128))
SPMAIN:BEGIN
 DECLARE annotatedSchema XML;
 DECLARE inputCursor CURSOR FOR SELECT ANNOTATED_SCHEMA from
 
 SHREDMAPPING WHERE SCHEMA_ID = :annotatedSchemaID;
 OPEN inputCursor;
 FETCH inputCursor INTO annotatedSchema;
 IF (SQLSTATE <> '02000') THEN
  BEGIN
   CALL SYSXML.AS_SHRED_BATCH(:sourceDataQuery, :annotatedSchema,NULL, :resultCode);
  END;
 ELSE
 
  SET resultCode = -1;
 END IF;
 CLOSE inputCursor;
END SPMAIN;
on calling it am getting below error ,
call MY_SHREDBATCH_SP('SELECT customerXML FROM CUSTOMER where customerID=1; ','annotatedcustomerschema.xsd‘,a);
 call MY_SHREDBATCH_SP('SELECT customerXML FROM CUSTOMER where customerID=1; ','annotatedcustomerschema.xsd‘,a);
***Failure 7504 in UDF/XSP/UDM TD_SYSXML.xml_gettabdef:SQLSTATE U0007:tABLE NOT FOUND
 
please help .

RCHAWLA 1 post Joined 01/15
09 Apr 2015

Hi Sayandeep,
Even I am facing the same error. Were you able to get through this?

M.Saeed Khurram 544 posts Joined 09/12
29 Jun 2016

Hi,
This is a very strange issue. I tried to multiple solutions but this problem is something need to be reported to CS. I was able to get only the folowing information from TD docs.

7504 in UDF/XSP/UDM %DBID.%TVMID: SQLSTATE %VSTR

Explanation: This is a UDF/XSP/UDM generated error. The meaning depends on the UDF as defined by the developer.

 

Generated By: AMP subsystem.

 

For Whom: UDF/XSP/UDM user.

 

Notes: The variable string will contain the SQLSTATE code followed by an optional text string supplied by the UDF/XSP/UDM.

Remedy: Look up the documentation for the UDF/XSP/UDM and take the necessary action to use the function in the correct context.

 

Br,

 

Khurram

Khurram

M.Saeed Khurram 544 posts Joined 09/12
30 Jun 2016

Hi,
This issue has been resolved. The issue ocurred due to a tag in annotatedschema definition.
There is a tag <defaultDatabase>Databasename</defaultDatabase>.
Update this tag with the database name in which your tables reside.
delete data from shredmapping table, reimport the annotated shcema, and then execute the procedure.
It will work without any issue.
Br,
Khurram

Khurram

You must sign in to leave a comment.