Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd May 2018, 21:11
vik.patil vik.patil is offline
Member
 
Join Date: Apr 2008
Posts: 54
vik.patil is on a distinguished road
Baan: ERP LN - DB: MS-SQL - OS: MS-WINDOWS
Unable to Insert Record in MS Sql Database from ION

Hi,

We are trying to create new Database Connection Point to Insert new Record in one of the Table in MS SQL Server. We have created new Stored Procedure to insert record by reading XML File. We have tested same from Database using XML file data template and it is working fine as able to get insert record into table. Now when we are testing same from ION and trying to Test Connection point we are getting following Error:
"Invoke operation 'TestAdapterConnection' failed. Adapter test connection failed: Failed executing sql statement for logicalId ' infor.database.connectiontest'. Cause: error converting data type nvarchar to int.

How to proceed with this error?

We have tested read database connection and we are able to get xml structure from database.

Any help appreciated.

Regards,

Vikram Patil
Reply With Quote
Sponsored Links
  #2  
Old 24th May 2018, 09:37
bbhawesh bbhawesh is offline
Member
 
Join Date: May 2012
Posts: 42
bbhawesh is on a distinguished road
Baan: BaaN 4, BaaN ERP, Infor 10 Enterprise - DB: SQL Server - OS: Windows, Unix
Check the BOD XSD for the BOD specified under "Document to receive" for this document under your DB connection point. Possibly it is not in accordance with the datatypes in the table.
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #3  
Old 24th May 2018, 15:58
vik.patil vik.patil is offline
Member
 
Join Date: Apr 2008
Posts: 54
vik.patil is on a distinguished road
Baan: ERP LN - DB: MS-SQL - OS: MS-WINDOWS
Thanks for your reply.

Document mentioned in Document to Receive option is used with File Folder connection Point and same file is used in Management Studio to pass to Stored Procedure and able to add record but from ION getting mentioned Error.

Following are Steps I have done to create database connection Point:
1. Added new Database Connection Point
2. Added information such as Host Name, Port Number, Schema, User Name and Password on Connection Tab and Clicked Test and able to get message as Test Successful.
3. Click Add Button, Mentioned Procedure Name and selected Scenario as Write Database and added Statement as EXEC spInsertPickList @xmlData='[Data]';
4. Clicked Test and added Data XML into Test Window as per instruction and again clicked Test. I am getting error message as follows:
"Invoke operation 'TestAdapterConnection' failed. Adapter test connection failed: Failed executing sql statement for logicalId ' infor.database.connectiontest'. Cause: error converting data type nvarchar to int."
5. I have tried with adding Document to Receive.
6. I have tried same thing with Document Flow and getting same error.

Please let me know if any possible steps missing.

Regards,

Vikram
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
insert in remote database (trigger) jbecker Operating Systems & Databases 1 8th March 2011 15:22
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35
how to insert record in type3 form via AFS??? alibaba AFS/DDC/OLE: Function servers 5 17th September 2004 04:19
Insert records in database directly from sql surinder Operating Systems & Databases 2 19th January 2003 17:24


All times are GMT +2. The time now is 05:40.


©2001-2018 - Baanboard.com - Baanforums.com