An error occurred while using the BCP utility-data was not correctly copied to the server.

(0) Share

Report

Posted on by Community Member Microsoft Employee

"An error occurred while using the BCP utility-data was not correctly copied to the server. " I get this error while trying to log into out DEV version of GP. Nothing is different except I am now on Windows 7 64bit. i *can* log into our live system without any issue. I have made sure UAC is turned off and I am starting GP with the "Run as Administrator" option. I can get past the login screen, but once I choose a company, any company we have, I get the above error. If I go to my old system, Windows XP 32bit, I can get into the DEV system with no issue. This only seems to be an issue with my new 64bit OS. My ODBC is set up using the 32bit version of the ODBC program (found here: %windir%\syswow64\odbcad32.exe).

Any ideas? I am really stuck on this one and need to be able to test my new apps on the DEV environment before I put them live.

*This post is locked for comments

All responses (18)

Answers (0)

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Ok Tracy, so let's put the DEX tracing aside, since this is not going to help anywhere... The DynUtils.exe is only a launcher for the main application Dynamics.exe (if you check the size of the first one, it's only about 163kb), so this is correct. I don't think that you'll be able to get around by installing the application in a different folder, but it's worth a try.

As Derek confirmed, you'll not be able to run the GP Utilities with UAC enabled, so if the installation of GP in a different location doesn't solve the issue, you'll be left with upgrading and installing in a different way : what I did with sensitive user (read don't want to give them perm Admin rights), is to put them temporarily into the local Admin group and have them login back to their desktop. Then proceed with the update/install of the GP client and first launch with GPU. Once done and tested an initial login into GP, have them logout and remove (remotly thru management tools) their login from the local admin group.

Finally, an another approach that should work would be to launch an elevated command line (with admin privileges) with your user-id, but in the user's desktop session. Than launch the GPU from the command line and sync the dictionnaries. Once done, your GP should start normaly. Try this out and let us know.
Tracy Matthews 330 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Beat was right in his response, bare minimum we have twice yearly updates. If we didn't I wouldn't worry about it. Then there is the individual deployments when the end users lauch GP the 1st time, it forces them into GP Utilities. Where they use their own userid/password. It only updates their client it doesn't touch system or company databases.

So, Beat, I don't have any answers yet for you. The Dexsql.log didn't get created when I was getting the administrator login. Then when I put in the administrator userid/password the file was created but 0 size. Then when I logged into GP it populated.

At this point my Vendor recommends we try to install outside of the program files folder.

We'll try a manual install outsode of this folder and see where we get. I will update you. it might be a couple days though. I need to acquire a PC.

One question.... I notice when I simply run GP Utilities and it comes up w/ administrator login it comes up that it's trying to run Dynamics.exe and dynutils.set. If I right click on GP utiliities and select run as administrator the prompt comes up with dynutils.exe. Why the difference?

Thank you all for the feedback,

Tracy
Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Hi Derek,

I could imagine that Tracy need to run the GP Utilities after a service pack update or a new GP client deployement... but You're completly right otherwise. The GPU is normaly not requested to run in the day-to-day operations from the end-user, so actually no reason to worry about.

Again, it's only an assumption and at this point she would have to login into the Desktop with her user and elevated priveleges to run the GPU.
Derek Albaugh on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Hello Tracy,

The question I have is why are the end-users, that aren't administrators, needing to launch into Dynamics GP 2010 Utilities?

The reason I ask is because unless they are updating databases or modified forms or reports, creating a new database or one of the other processes within Utilities, they shouldn't need to go into Utilities at all.

Besides the BCP error, which your only options are to disable UAC or use the 'Run As Administrator' permissions, you would need to login to Utilities as either DYNSA or SA, and my thinking is that if you're unable to give the end users the local administrator permissions on the machine that Dynamics GP is installed onto, you're definitely not going to give them the SA or DYNSA login password, which would give them almost all permissions within Dynamics GP and/or SQL Server.

Let me know if you have questions on the above information.

Thank you,
Tracy Matthews 330 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

I don't have a screen shot as I got called in to work on the problem after the test PC's were already updated. The Tech Staff is removing the GP client from a lab PC and putting it back on so I can try it.

Once she reinstalls GP I will turn on the logging in dex.ini and repost.

BTW. . . she did give Full control right from Program files on down at one point but it didn't help.

Again . . Thanks,

Tracy
Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Can you please provide an exact copy of the error message that you get ? Maybe it's worth trying to enable the DEX log tracing in the DEX.ini file :

[General]

SQLLogSQLStmt=FALSE

SQLLogODBCMessages=FALSE

SQLLogAllODBCMessages=FALSE

replace all the FALSE by TRUE and save the file (you may need to open the notepad with Admin rights to be able to save the changes).

Start the DynUtils again and then look if you can find some .LOG files in the Data folder. Check also the presence of duinstall.log and it's content.

Don't forget to change the DEX.ini file back to FALSE after your attempt, otherwise the LOG files will keep growing forever.
Tracy Matthews 330 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

I just double checked . . . All files (du*.dic, and dynutils.dic and dynamics.dic) are in the gp folder where the users have full control.

I think it's strange that this GPO works fine for GP10 on Windows 7 using UAC. Could it have anything to do with ODBC? We use the 32 bit version and for GP2010 we use SQL Server Native Client 10.0.

Otherwise could GP2010 Utilities update something that GP10 Utilities doesn't?

Thanks a lot for your time. . . .

Tracy
Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Hi Tracy,

I have never tested the option thru GPO for the GP directory, but theoratically this should work for the GPUtilities.exe too, since it's located in the same subfolder.

Now you may want to check where your DynUtils.dic file is located... does it reside in a location that's accessible in R/W mode ? Generally speaking all the .DIC files need to be accessible in R/W to run Dynamics GP properly (and that is certainly true for the GP Utilities). The DYNUTILS.SET launch set is a smaller sub-set of the DYNAMICS.SET file, but the rules are essentially the same, except that all the .DIC files are starting with DU*. Check the location of all those files and their R/W accessibility.

Hope this helps.
Tracy Matthews 330 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

We do use Citrix for External users of GP but internally the cost would be prohibitive. Not something we'll pursue.

The Great Plains Active Directory group has been given Full Control Access to the "C:\Program Files (x86)\Microsoft Dynamics" through use of a group Policy, shouldn't that be enough? By doing this, Great Plains itself is no longer prompted at any point for administrator. Just Utilities. Also. It's only for GP2010. Giving the group Full control to the Microsoft Dynamics Folder fixes the issue for GP 10 AND GP Utilities 10. It's only GP 2010 that has the administrator prompt in Utilities.

I can ask then to provide access at the "C:\Program Files (x86)" level for testing purposes if you think this will help.

Tracy Matthews
Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

Re: An error occurred while using the BCP utility-data was not correctly copied to the server.

Hi Tracy,

The KB870416 will not be of any help in your case... (and you have to get it only thru the customer source, because it's a confidential article).

I'm not aware of any solution to run GP (any version) in a Windows 7 / Vista environment without disabling the UAC and/or putting the end-user into the local administrator group (i've spent many hours of testing in this and couldn't find a viable solution).

The problem comes from the fact that the entire 'Program Files' folder under the new OS platform is system protected and accessible in read-only mode for a regular user. Even an authorized admin will sometimes get prompted by the system when doing some operation (like copy/move/paste files) in the PF folders, and this although the UAC is disabled and the user has local admin permissions...

Microsoft wanted to make the whole Windows platform more secure and less easy to fall apart by malware, and in some way they achieved that, but it went on the cost of easines of managing the applications. The most troubling is the fact that MS is the company that develops the Dynamics GP product and cannot get around the UAC and permission problem. Dynamics GP needs to be able to write into the PF folde where GP is installed...

Since the upgrade to Windows 7 in our company, I've massively reduced the amount of distributed GP clients and force most users to access it thru our Citrix application server... That not only cuts the maintenance to a minimum, but also avoids the hassle with the local security on the systems. Only a few users who uses a specific module that is not availabel to everyone gets a local copy of the GP client.

Hope this helps in your quest...