DynDeveloper.com

We recently upgraded a client from GP 9 to GP2010, and along with that the SQL Server upgraded from 2000 to 2008.

This client is heavily customized (because... that's that we do) and they have about 30 triggers running on Dynamics tables that power business logic. We were paniced to learn that SQL treads triggers differently in 2008. Triggers that didn't recurse now recuse to the maximum level allowed (32) and then throw an error. Very, very bad.

We experimented with turning off the SERVER setting of 'Allow triggers to fire others'... but we need that to happen.

We looked at the DATABASE setting of 'Recursive triggers enabled', that is set to false and we're OK with that. We don't want the same trigger calling itself.

We think it's largely the blame of new triggers that are present in GP 2010 that update the table that they're built on, and that fires our triggers... and you get an echo effect of triggers calling triggers.

So... here's our solution.

This article will cover deploying the suite of SSRS reports that comes bundled with Dynamics GP 2010, and also cover the errors that we encountered and how to fix them.

Errors:

The SQL Server Reporting Services setup information is not valid

The deployment exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.

(in part)

rsItemNotFound

The item 'Report Models/<companyName>/<companyName>_Inventory' cannot be found.

 (in part)

rsItemNotFount400The item '/<companyname>/Purchasing/Charts and KPIs' cannot be found.

Ever since I started coding in Visual Studio 2012, I'm seeing the following warning in eConnect projects:

Warning:
There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "C:\Projects\LRVTools\LRVLibrary\bin\Debug\LRVLibrary.dll", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project. LRVService

It's not a serious thing, but it is an irritation. This article briefly discusses the warning and how to remove it.

We just started getting a new error on web services. There have been no changes to the code base.

System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: A validation exception has occurred.

Validation Errors:

- Unable to get payment number

Not sure why this is happening. We are updating an existing sales order that has a payment attached.

Hi,

I am trying to upgrade my GP 10 SP 3 to SP 4.  When I click the installation package everything runs smoothly.  Then I open GP Utilities and as expected it tells me that I have to upgrade my databases.  When it starts the upgrade I almost immediately get the following error

The following SQL statement produced an error:
 CREATE UNIQUE NONCLUSTERED INDEX [AK2EXT40800] ON [dbo].[EXT40800]  ( [Extender_Menu_Name] ASC, [DEX_ROW_ID] ASC ) ON [PRIMARY]  

Any ideas of how to solve this?

Thanks

I have an item that is showing -1 Sold on the Item inquiry window, the On hand = 3, Allocated =1, Available = 2, On order =250, and the rest are 0. I did an inventory reconcile on that Item number but it didn't help, is there any way to fix it in the tables?  I know that IV00102 has the Negative value but I doubt it would be as simple as just  totaling the Quantity Received and subtracting the Quantity Sold displayed on the Purchase Receipts Inquiry window then changing the QTYSOLD value on IV00102 to 158 (Quantity Received =161 - 3 Not sold = 158) 

Thanks in advance for any help

i was running through the installation media for gp11....i found under the "AdProd" directory something called "OSSWizard".

can someone tell me what this is?  i have already installed the business portal for sharepoint 2010, but i have no idea what this is for.

thanks.