Have you seen This? POP Error

(0) Share

Report

Posted on by Community Member

This error can re-create or happens on all Windows 7 clients. Every time, users select Home > Purchasing > Purchase Order Transactions. They receive this error. Click OK and continue on just fine. Strange!

Server:
Hyper-V R2 SP1 Host
SBS 2011 as Guest
SQL 2008 R2 Express RTM on SBS 2011
GP2010 R2 RTM

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Have you seen This? POP Error

Are you saying you have a mixture of XP and W7 computers and only the W7 clients do this? I would check the DSN and make sure you have unchecked the 'Allow ANSI Nulls' box on the DSN.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Have you any other third party products installed, or any custom developments?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Thanks Richard and Ian for your quick response.

My experience is that when GP gurus/MVPs replied with questions, I know I'm in for the worst. Therefore, I've done more diligent tests before posting reply.

A bit of background:

The GP database were running on old server with SBS 2003, SQL Server 2005 Express SP3 32-bit, and GP2010 RTM (11.00.1247). GP Client installation without Analytical Accounting (AA) feature and the only additional dictionary added was "Check Amount to Words" dictionary. No other third-party products installed.

Below are my tests with different mixed and match GP and SQL version configurations and results:

Note: all tests are now performed on the new server which is running SBS 2011 and GP installed without ChktoWords chunk/dictionary. Database compatibility is at (90) for all SQL versions.

C1: SQL Server 2008 R2 Express 64-bit + GP 2010 R2 (11.00.1752 SP2) with AA.

Results: Error (Bad)

C2: SQL Server 2008 R2 Express 64-bit + GP 2010 RTM (11.00.1247) with AA.

Results: No Error (Good)

C3: SQL Server 2005 SP3 Express 64-bit + GP 2010 RTM (11.00.1247) with AA. (Similar to Old Server versions except 32-bit)

Results: No Error (Good)

To conclude that the GP R2 was the culprit not the SQL Server. The error only popups when All Purchasing Transactions and Purchase Order Transactions are selected. Other options in the Purchasing panel are fine.

Is it a B... U... G in the R2? Is anyone currently running R2?

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Hi - report it to MS. Through your GP Partner if you have one. You got the error in a supported enviornment and have tracked it down to the SP2 install (if your testes are 100%). You can re-create it so you should get a good response.

Keep us updated.

Ian.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Have you seen This? POP Error

I would add that you try running SQL Server Profiler on your server with your partner and execute the same commands and you should see what command actually causes this error. I believe the screen to which you refer is when you go to lookup a PO. That uses code from Smartlist and it would be that code that has

the bug. You are seeing a screen similar to this, correct?

The window is trying to create a temp table with PO's sorted and then it will display the results. It sounds like the script building this table has the issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Richard, No. The error happens every time a user selects:

Purchasing -> All Purchasing Transactions or Purchase Order Transactions

as shown in the figure. If you notice the white background on the right panel, the error happens right before anything to be rendered there. Just click the OK button, the Banner and the DataGrid for POP transactions will be loaded normally.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Have you seen This? POP Error

OK, now I see where you are. If you go into the TWO(Fabrikam) company or any other company does this problem occur?

I just tried this on a demo GP2010 R2 image I have and did not have this problem. I also ran SQL Profiler and I can see several create temp table statements where CONTACT is set to be NOT NULL.

Just out of curiousity try running this script against your company database:

select * from pm00200 where vndcntct is null

Does it return any records. It should not but maybe you have some null contacts in the vendor table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Hi Richard, thank you for keeping up with me. It takes me awhile to figure out how to install the SQL Profiler with the Express version. And this is what I got from the Profiler right at the error appears:

SELECT COUNT(DOCDATE) FROM ##1611629

go

SELECT COUNT(DOCDATE) FROM ##1611629

go

TRUNCATE TABLE ##1064231

go

BEGIN DECLARE @stored_proc_name char(35) DECLARE @retstat int DECLARE @param10 int set nocount on SELECT @stored_proc_name = 'ACME.dbo.LoadPurchasingTrxListData' EXEC @retstat = @stored_proc_name '##1064231', 12, 1008, '2011.04.13', '2011.07.11', 1, 0, 3, '1=1', @param10 OUT SELECT @retstat, @param10 set nocount on END

go

Is there a reason why the table get truncated?

In addition, I also tried to fill the VNDCNTCT field with 'NA', instead of leaving it blank. Is a blank field in SQL a zero-length string or NULL?

I ran the statement you provided and it returned no records.

Hope you can help.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Have you seen This? POP Error

Before going to that screen, try going into SQL and run this script.

if object_id('tempdb ##1064231') is not null

begin drop table ##1064231

It is complaing about a global temporary table which should get purge. Perhaps something in cache is hanging onto this table.

If it says 1 record delete then you know if was in there. Then try to enter another PO. If the problem remains then there is some bug in the GP code.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Have you seen This? POP Error

Mariano Gomez has posted a solution at this link:

feedproxy.google.com/.../cannot-insert-value-null-into-column_11.html

However, our situation is a bit different. The reason the VendorID is null because when we enter an In-Transit Inventory transaction (in the Receiving Transaction Entry window), the VendorID field is not allowed (disabled).

Hope anyone has a solution.

Was this reply helpful? Yes No