Thursday, July 17, 2014

Dynamics GP - "The Deployment has exceeded the maximum request length allowed by the target server" when installing reports

Problem

When installing reports in Dynamics GP i'm running into the following error


Solution
Navigate to the Reporting Services folder and add maxRequestLength="20690" to the httpRuntime node. The folder should be located here: \Program Files\Microsoft SQL Server\MSRS10.[SSRSInstanceName]\Reporting Services\ReportManager



Monday, July 14, 2014

How to see who has files open in shared

Problem
I went to remove sharing from a shared folder because I'm migrating the data to another server. Windows said something like "there are N users with opened files. By removing this share you will boot them"

Solution
This is on Windows Server 2003, probably different in newer versions...

1. Computer Management
2. Shared Folders
3. Open Files

From there you can see who has what open. In my case it was me with 7 sessions opened. So I right-clicked all of my sessions and closed the file connection. Then was able to remove Sharing from that folder without complaints.

Reference
http://stackoverflow.com/questions/581219/find-out-who-is-locking-a-file-on-a-network-share

Tuesday, July 1, 2014

In Dexterity - Passing in a checkbox for a boolean parameter results in it flipping the value

Problem
I'm passing a checkbox field, specifically CMTransactionObject:'Auto Post To GL', to a script which is expecting a boolean. 'Auto Post To GL' is a checkbox type.

I put warning messages, like this warning str(CMTransactionObject:'Auto Post To GL') before the script is called, and then as the first statement in the script itself.

Results:
Before script - 1
In script - 0

Solution
Explicitly cast the checkbox to a boolean.

Way 1-
local boolean value = CMTransactionObject:'Auto Post To GL';

call script, value;

Way 2-
call script, boolean(CMTransactionObject:'Auto Post To GL');
This way should not be done with inout parameters, only in.

Note:
This actually seems to be caused by passing a local variable to two different parameters, one with in one with inout
There was an error in this gadget