export error

[cjuimtu]

hi all
I am having trouble with exporting an A/P batch. After I chose export and select the application and where I want to save it to be saved and click ok, I get an error message: "Arguments are of wrong type, are out of acceptable range, or are in conflict with one another. "


Accpac version 5.5 500
database MSQL 2003
OS windows server 2003
service pack 2

 

[Jay Converse]

What export format are you using?

 

[cjuimtu]

excel 2000

 

[Jay Converse]

Try unchecking some of the fields.

 

[cjuimtu]

tried unchecking some fields but not responding

 

[Jay Converse]

1. Can you export a different batch?
2. Can you export that batch from another workstation?
3. What's the SQL collation order?
4. Run RVSPY and see if it tells you exactly which field has the problem.

 

[cjuimtu]

Can you export a different batch?N
Can you export that batch from another workstation?NO tried atleast 2 workstations
how do u check the collation order?

 

[Jay Converse]

MSSQL Database properties.

You still need to try Rvspy, and adding Dbspy would help, too.

Also run Database Setup/Verify to see if somebody has been screwing with the data dictionary.

 

[ettienne]

Try a different format like Single CSV.

 

[cjuimtu]

using Single CSV
i get another error '" Payments/Adjustment Attempt to access disabled field 'Encrypted C.C. Number'.

 

[Jay Converse]

That's a screwy error, something basic is wrong with your install. Start by installing SP4 for SM and SP3 for AP, those are the current ones.