Saviynt Forums

Rajesh_IAM · ‎05/22/2023

Hi Team,

Its a DB connector.

I was trying to import accounts from target (DB based application) to Saviynt and getting error as "Column count doesn't match value count at row 1". Even I verified that all the columns in select are mentioned in mapping.

Attached is the import text file.

Could you please check and help me to resolve this import issue.

sudeshjaiswal · ‎05/22/2023

Hello @Rajesh_IAM

Column count doesn't match value count at row 1 - This error means that all columns are not being passed as expected. Are you sure that all mapped columns having mentioned in select statement and have data?
Please try removing the square brackets and rephrasing the XML Query referencing the below sample,

<dataMapping>
	<sql-query description="This is the Source Database Query">
		<![CDATA[SELECT CAST (ComputerID as CHAR) as entID, [Computer Name] as entitlementvalue, OS as cp3,1 as status, [Asset Type] as entitlementtype, 'Dev_Asset' as applicationname, 'Dev_Asset' as endpointname FROM ASSETS WHERE LTRIM([Computer Name]) LIKE 'ABQ-P%']]>
	</sql-query>
	<mapper description="BigFix Asset Import" deleteentitlementowner="true" entnotpresentaction="noaction" createentitlementtype="true">
		<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="applicationname" type="character"/>
		<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointname" type="character"/>
		<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>
		<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="entitlementvalue" type="character"/>
		<mapfield saviyntproperty="entitlementvalues.entitlementID" sourceproperty="entID" type="character"/>
		<mapfield saviyntproperty="entitlementvalues.customproperty3" sourceproperty="cp3" type="character"/>
		<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"/>
	</mapper>
</dataMapping>

for ref:- https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Configuring-the-Integration-for-Impo...

Thanks

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Rajesh_IAM · ‎05/22/2023

@sudeshjaiswal
Thank you for your response.

Yes, all the mapped columns are mentioned in select statement and also verified that one column(notesFullName) has null value for few users.
Even I tried with removing square brackets in select statement.

Rajesh_IAM · ‎05/22/2023

@sudeshjaiswal Still facing same issue. Column count doesn't match value count at row 1

sudeshjaiswal · ‎05/22/2023

Hello @Rajesh_IAM,

Can you please share the XML Query?

Thanks,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Rajesh_IAM · ‎05/22/2023

@sudeshjaiswal Please find the attached file.

dgandhi · ‎05/22/2023

Can you try below?

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

sk · ‎05/22/2023

Can you please share the logs during the import?

Also what are the data types for each column from your select statement on the application from where you are pulling the data.

I believe one of the column mapping is not happening properly because of which you are receving this error.

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak · ‎05/22/2023

Share sample output

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Rajesh_IAM · ‎05/23/2023

@rushikeshvartak Please find the sample output

sk · ‎05/23/2023

@Rajesh_IAM I see some of the column values are coming as numbers not sure on source side it is number or varchar but since you are mapping to varchar column in saviynt I suggest to do casting like this and in mapping make sure you have used data type as character

cast(employeeNumber as VARCHAR) as employeeNumber

Do the same thing for following columns

abbGEIDLocalID

abbEmploymentStatus

Manager_employeeNumber

Manager_abbGEIDLocalID

Manager_EmployeeID_SSO_ID

Try below

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Rajesh_IAM · ‎05/23/2023

@sk Thank you for your response.
I have tried with provided XML data, but still getting same error. Post that I have tried this account import for one user (using where condition in select statement) and got success. Then again tried for another user, now import failed. As of now, we have 3 test users records in DB. Out of 3, 2 users import is failing and for only one users, import got success.
I am not sure why its working for one user and not working for other users.

sk · ‎05/24/2023

@Rajesh_IAM : Would you be able to share the data of success vs failed records? Also logs for both runs?

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

dgandhi · ‎05/24/2023

I believe the issue is in your mapping only. Please try to run import with limited mapping , this way you can narrow down which field is causing the issue.

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

sudeshjaiswal · ‎05/22/2023

Hello @Rajesh_IAM,

Only Removing the square bracket won't work, as I have shared the sample above with you to create the alias as shown in the example. Please do that and try again.

Thanks,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Saviynt Forums

Column count doesn't match value count at row 1 error for DB Connector