Hi All I try to import some workgroups and members from an SQL table. Basically it's very simple but I get strange error messages like:
While processing WORKGROUP_MEMBER (id = 428): JDBC error 8114: [SQLP30-CHBS]Error converting data type nvarchar to numeric., SQL state: 01000 for query: select t1.mem_oid as c0 ,t1.mem_wog_oid as c1 ,t1.mem_per_oid as c2 , cast(? as numeric) as c3 ,t1.mem_lockseq as c4 from cdm_members t1 where (t1.mem_wog_oid = ?) and (t1.mem_per_oid = ?) Values: 624492548 BC-ASIAPAC-SA-BAS-SUPPORT KHATRPA1com.inet.tds.SQLException: Msg 8114, Level 16, State 5, Line 1, Sqlstate 01000 [SQLP30-CHBS]Error converting data type nvarchar to numeric.
I made the mappings and scripts according to the well described Organisation/People example in the hp documentation.
My INI file looks like:
[WORKGROUP] SOURCE=[WorkGroupMembers] [wg] ATT=[SearchCode],[WorkGroupName] COLUMNS=DISTINCT [wg].[SearchCode] AS [SEARCHCODE], \ [wg].[WorkGroupName] AS [WORKGROUPNAME] LOADTABLE=TRUE
[WORKGROUP_MEMBER] SOURCE=[WorkGroupMembers] [wg] ATT=[wksc], [pers] COLUMNS=DISTINCT [wg].[Searchcode] AS [WKSC], \ [wg].[PersonSearchCode] AS [PERS] CONDITION=[wg].[Searchcode] IS NOT NULL AND \ [wg].[PersonSearchCode] IS NOT NULL LOADTABLE=TRUE
I don't have any clue where the conversion should take place. Any ideas?