Integration Manager error

(0) Share

Report

Posted on by Meredith Villatore

115

i'm getting the following message when trying to run integration manager into the payroll module. I am able to run other payroll integrations, but when using a specific file, i get the following message. i've tried recreating the integration file, copying the data into a working file, but keep getting "relationship" issues. Any solutions to try are greatly appreciated.

2705.error.png

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

twelvestrikes 3,657 on at

Like (0)

Report

Hi Meredith

At a quick look at this error message, it appears that you have multiple files for the import and no relationship is set between the files.

If you look below the Sources section in Integration Manager you will see Query Relationships

Double click to open that and you can then map a relationship between your files.

Was this reply helpful? Yes No
Meredith Villatore 115 on at

Like (0)

Report

Yes, but i can't get the columns to pull in from the transaction file. Because of that, i can't link the relationship. I even tried to use the same file for the header and the transactions. it pulls in for the header, but not for the transactions.

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

Hi Meredith

What type of source file are you using? Is it a Text, CSV, or excel file that you are connecting with an ODBC driver?

If you look at your source files in the integration, right click on one of the source files and select Properties.

If a Text or CSV file make sure that you are mapped to the location of the file. Click on Columns. Do you see anything here?

You may want to do a Column Refresh.

Close the property window

Right Click again and then select Preview.

Does any data get returned?

If yes, do the same for the next file.

Then go into the Query Relationship window

Was this reply helpful? Yes No
Frank_Heslin 895 on at

Like (0)

Report

Hi Meredith,

Please verify if you have a relationship setup between the two files. Open the integration & click on Query Relationships

Do you have any links between the two files?

Once there is a relationship setup, verify that all the Mapping is setup too.

Let us know if all of these pieces are in place.

Was this reply helpful? Yes No
Meredith Villatore 115 on at

Like (0)

Report

I'm using a csv file. the same one i've used in past years and had no issues with. the problem i'm having is that the columns are not coming through from the file. so for the header file, I will have the column, but in the transaction file, the columns are not pulling in for some reason. Thus, i cannot map them.

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (1)

Report

Meredith

For your detail file, right click and choose properties.

Click on the sorting tab and make sure that there are no Group by's selected.

Your group by's should only be in the header file.

Are you running any scripts before the integration for before the query?

Was this reply helpful? Yes No
Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

Under Sources, double-click on the Transactions file to open the Properties dialog box. Then click on the Columns tab. Do you see any columns listed?

Either way, click Refresh Columns, and then Apply & OK.

Once you've done this, right-click on the Transactions source file name and click Preview filename. If you see any data then you should be able to setup the relationship if needed, and then map them as well.

Let us know.

Was this reply helpful? Yes No
Verified answer

Meredith Villatore 115 on at

Like (0)

Report

This worked! Thank you. I wasn't running any scripts.

Was this reply helpful? Yes No