Running IM on a development server

(0) Share

Report

Posted on by Community Member

We've created a development GP 2013 server. We have custom IM tables that are used for integration. Whenever we run the Integration we get the following error.

DOC 2 ERROR: Field 'Document Number' does not have a default value. - Destination Field

ID: Document Number - Field Value: T-8006-02

DOC 2 ERROR: Field 'Distributions.Distribution Account' does not have a default value. -

Destination Field ID: Distributions.Distribution Account - Field Value:

It states the batch does not exist but the batch was created and it's status is "Avaliable".

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

What kind of integration is this? POP? Payables? SOP?

Was this reply helpful? Yes No
JJdynamics 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Frank,

This is Payables Transaction. I work with AnettaJ. We both are working on this issue.

Thanks

Justin

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

The error messages indicate that your mapping has 'Default' set as the source for Document Number and Distribution Account but there are no defaults set in GP for those values. Should those values not be coming from your source file?

Was this reply helpful? Yes No
JJdynamics 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Frank,

Thanks for your reply. No they are not set as default. I have set it to take from the Use source field. That is what I have set in the mapping section.

thanks

Justin

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

Okay, next question - what is the nature of the 'custom tables' referred to in the first post?

Was this reply helpful? Yes No
JJdynamics 25 on at

Like (0)

Report
Copy link

Link copied!

The Custom tables actually refer to the source Text files. These are comma delimited files.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Frank has you looking at the source table - question would be 'are there values that are real account number or index values in that table?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

It's really challenging to troubleshoot an issue like this online because of the number of variables associated with an integration but I would be looking at the integrity of the source file. Check to make sure that no blank rows or fields exist. Let us know what you find.

Was this reply helpful? Yes No
JJdynamics 25 on at

Like (0)

Report
Copy link

Link copied!

Yes the source file does have a GL account number as one of the fields. But the error does not indicate to that field. I don't know if that helps.

Was this reply helpful? Yes No
JJdynamics 25 on at

Like (0)

Report
Copy link

Link copied!

There are no blank rows or fields. It is a 2 row file. I am testing with a sample file.

Also, I am curios about one thing. The integration manager was installed with configuration from a production server. I moved the access DB file to the local DEV server and recreated a new integration with the source and the destination. Is it possible that even though I created a new integration the mapping might still be pointing to the other server? Is there a way to find out from IM which GP server it is pointing to?

thanks,

Justin

Was this reply helpful? Yes No