Service Desk Practitioners Forum
cancel

SD5 Import of Workgroups and Members

Highlighted
Hanspeter Loche
Super Contributor.

SD5 Import of Workgroups and Members

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?

Thanks for help
Hanspeter