Asked a question 10 months ago

unable to load publisher data using continuous Load


Fathia Jama SEMARCHY TEAM
Hi Rakesh, to provide the best answer could you provide additional detail please. When you say you are unable to load publisher data using continuous load, is this a SQL load or a REST API load? Are you receiving any error messages?
Rakesh Jamla 
Hi Fathia,
I created 3 publishers based on 3 source tables in sql server database for Semarchy. Then I created a Job to load data into my Location entity and scheduled for 11:15 am daily but It's not pushing the data into Location entity. I create a continuous load but it's not moving the data either.


Fathia JamaSEMARCHY TEAM
Sr. Customer Success Consultant at Semarchy

A continuous load provides the load id used to submit the load, but you will have to load the actual data either by using SQL or REST API. I would suggest taking a look at our tutorials. They can walk you though loading data using your preferred method. 

Rakesh Jamla 
I am not using SQL script. I just created a continuous job to load the data.
Rakesh Jamla 
Unable to load data using continuous load UUID in SA table using insert sql query. getting error- Error converting data type varchar to numeric
Fathia Jama SEMARCHY TEAM
Rakesh Jamla Can you provide the SQL query you are using?
Rakesh Jamla 
here is the query- INSERT INTO [dbo].[SA_LOCATION]
([B_LOADID]
,[LOCATION_ID]
,[B_CLASSNAME]
,[B_ERROR_STATUS]
,[B_ORIGINALBATCHID]
,[B_OPERATIONID]
,[B_DUPSOPERATIONID]
,[B_DUPSMERGETARGET]
,[B_DELETETYPE]
,[B_DELETEDATE]
,[B_DELETEAUTHOR]
,[B_DELETEOPERATION]
,[B_DELETEPATH]
,[B_COPIEDFROM]
,[B_CREDATE]
,[B_UPDDATE]
,[B_CREATOR]
,[B_UPDATOR]
,[SRC_CD]
,[SRC_LOC_ID]
,[LOC_ID]
,[SRC_LOC_NM]
,[SRC_LOC_DESC]
,[DELPHI_LOC_CD]
,[DELPHI_LOC_NM]
,[CREATE_DT]
,[CREATE_USER]
,[UPDT_DT]
,[UPDT_USER]
,[B_AUTHORINGTYPE])

SELECT CONVERT('57F9E61C-8B6A-4394-B1E0-B7EA617EFBEE' AS DECIMAL(38,0))
,CAST('47AD1215-9FB9-41F1-9B1B-6276002059E3' AS DECIMAL(38,0))
,'Location'
,' '
,CAST('' AS DECIMAL(38,0))
,''
,CAST('' AS DECIMAL(38,0))
,CAST('' AS DECIMAL(38,0))
,''
,''
,''
,''
,''
,CAST('' AS DECIMAL(38,0))
,''
,''
,''
,''
,[SRC_CD]
,[SRC_LOC_ID]
,CAST([LOC_ID] AS DECIMAL(5,0))
,[SRC_LOC_NM]
,[SRC_LOC_DESC]
,[DELPHI_LOC_CD]
,[DELPHI_LOC_NM]
,[CREATE_DT]
,[CREATE_USER]
,[UPDT_DT]
,[UPDT_USER]
,''
FROM [dbo].[XREF_LOCATION_MADRIS]
Fathia Jama SEMARCHY TEAM
The B_loadid should not be CONVERT('57F9E61C-8B6A-4394-B1E0-B7EA617EFBEE' AS DECIMAL(38,0)). If you take a look at the semarchy tutorial on Load Data via SQL API, Step 7 shows you how to call the continuous load id. semarchy_repository.get_continuous_loadid('CONTINUOUS_LOAD_INTEGRATE_ALL') as b_loadid. Please review the tutorial for more details.