Fix Computer Problems - fixcomputerproblems
last updated on: 31/05/16 03:20AM
   Tips for Troubleshooting 37000 Line 11 Incorrect Syntax near 39 39 when generating rep [18/05/16 09:13AM]   
Rate this post  

Summary:

Resolution: Fixing 37000: Line 11: Incorrect Syntax near '*' when generating rep errors is a really difficult task for most computer users. In order to fix your errors and speed up PC, it is recommended that your download the '37000: Line 11: Incorrect Syntax near '*' when generating rep Repair Tool'. This is an advanced optimizing tool the can repair all those problems that are slowing your computer down.

Download 37000: Line 11: Incorrect Syntax near '*' when generating rep Problems Fixer Now

In order to repair 37000: Line 11: Incorrect Syntax near '*' when generating rep error, install SmartPCFixer immediately. This system optimizer software is already proven to locate, identify, and repair 37000: Line 11: Incorrect Syntax near '*' when generating rep errors. Your computer should run faster and smoother after using this software.


Manual Solutions

Issue Summary:

37000: Line 11: Incorrect Syntax near '*' when generating rep

Issue Detail:

Description:
When generating a report that includes a range of accounts in the row format and the client has 100 or more companies in Solomon, the following errors occurs...

FRx Reporting Engine
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 11: Incorrect syntax near '*'.
OK Cancel
<>
FRx Reporting Engine
This report yeilded no data.
OK

However, the above error only happens for certain companies of the 100 or more created. This error will occur using companies numbered 99 or less and will occur with companies numbered 100 or more. Therefore, the error is not just limited to companies created after the 99th one.

Steps to Recreate:
1.)Install FRx 6.5.184 for Solomon using any of the Solomon OFSIs provided for this version (6.5.259, 6.5.260, 6.0.0.16)
2.)Set up a company with the following information
GL ODBC Data Source Name:
Server: minyasql2000_52
Login ID: master
Password: xrf
Change Default Database To: SOL55_NBAAPP_KS System
Database Name: SOL55_NBASYS_KS Master
Password: xrf (field only appears if logged in as FRx administrator)
Natural Account Length: 5
Company ID: RMI
3.)Set the above company as default
Login ID: sysadmin
Password: blank
4.)Create a simple row format with the following range: (00101 TO 00126)
5.)Create a simple column layout like the following:
DESC GL-ACTUAL-BASE-BASE-CUR GL-ACTUAL-BASE-BASE-YTD
6.)Create a catalog with the above row and column. Use report date of 1/31/2004 and use financial report detail only.
7.)Generate the report.

Incorrect Result: FRx Reporting Engine Receive the following error: 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 11: Incorrect syntax near '*'. Followed by "This report yeilded no data."

Expected Results: The report should run without error.

Workaround:
The only known workaround at this time is to somehow get the client under 100 companies in Solomon. Also, rerunning the scripts has fixed this issue a couple of times but that is not a reliable fix as it doesn't fix the issue in all cases.

Status of Resolution:

This issue has been addressed in 6.5.184.

This article was TechKnowledge Document ID:
5250

What Else Does SmartPCFixer Offer You?

SmartPCFixer™ is not only able to troubleshoot 37000: Line 11: Incorrect Syntax near '*' when generating rep error, but also help identify and fix Windows' invalid registry entries. By running Scan & Cleaner as part of scheduled maintenance, it will keep your PC from freezing or frequent crashes . Using it will reduce the probability of you getting a "blue screen", program not responding or lock up.

SmartPCFixer provides you with Registry Backup, System Backup, Favorites Backup and Folder Backup. In addition, the new built-in function of Restore Point enables you to create a system store point so you can recover your system to a previous state if you do not like the changes you have made. This ensures the safety of your system when you run the registry repair process.



Related: Pop Up Ads,Toolbars Internet Explorer,Plugins Chrome,Internet Explorer 10 Free Download,Download Ie9
Read More: ,explorer for vista,windows error 32,error 1719 windows installer service,shockwave flash download,explorer exe windows explorer



   Trackbacks

      TRACKBACK URL: http://fixcomputerproblems.blogghy.com/trackback/759584

   Comments

   Post a comment
Name:


Email:


3 + 1 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
How to Fix the Problem The control total and the batch total on a batch differ in Accounts Payable in Microsoft Dynamics SL
[31/05/16 03:20AM]
How to Fix The Inetinfo exe process stops responding when you enable the Envelope Journaling feature in an organization that is running Exchange Server 2003 SP2
[31/05/16 03:13AM]
How to Troubleshoot FIX Visual Studio 2005 incorrectly interprets a query that uses keywords that are specific to third party databases when you use the TableAdapter Configuration Wizard Problems
[25/05/16 10:29AM]
Tips for Troubleshooting How to configure your FrontPage server to use WAIS search engine instead of Index Server
[25/05/16 10:20AM]
Error Message SGL DLL File Cannot Start Problem Causes and Solution
[19/05/16 03:46AM]
Top views posts
Why You Shouldn t Ignore Kb183110
[04/05/16 03:17AM] Daily Views 10
Error Message Cannot Delete File File System Error 1026 Fix Utility
[19/05/16 03:42AM] Daily Views 10
Error Message SGL DLL File Cannot Start Problem Causes and Solution
[19/05/16 03:46AM] Daily Views 10
Need for Fixing Dxwebsetup exe For Windows 7
[04/05/16 03:19AM] Daily Views 2
Clicking View Files in Disk Cleanup Tool Does Not Display Files How to Repair
[18/05/16 09:13AM] Daily Views 2
Photo Albums








Powered by Blogghy

Page generated in 0.221 seconds.