The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Error getting native IReport object. This field name is not known.
Posted: 15 Mar 10 9:52 AM
|
Hi all,
My Current Saleslogix version is 7.5.2. When ever i am clicking on the generate report button in saleslogix lan client i am getting the following error messages
---------------------------
---------------------------
Error getting native IReport object. This field name is not known.
---------------------------
OK
---------------------------
---------------------------
SalesLogix Report Manager
---------------------------
Unable to retrieve the report.
The report cannot make an OLE DB connection.
Please contact your administrator.
---------------------------
OK
---------------------------
As far as i know we dont need any crystal report licenses for generating the core reports from lan client. If we need to modify or develop new reports then we need crystal report licenses. But i am not getting why i am facing this issue while generating the reports.
To be more precise i am only getting this error in production database but not on dev database.
In production Database we do have migrated data from salesforce. The strange thing is i am getting this errors only over the tables where i have created customized fields but i am not getting the same error for the tables which are out of scope from our project. In fact i am not getting this error over the tables which we haven't touched.
Any ideas
Thanks in advance
Regards
mark
|
|
|
| |
|
Re: Error getting native IReport object. This field name is not known.
Posted: 17 Mar 10 4:10 AM
|
we have created almost all the fields from the slx db manager. But some fields probably few fields we have created from sql server management studio what we have to do in that case. I also feel the same when i got this error.SO whats the solutions for this problem Any idea
Thanks in Advance
Mark
|
|
|
| |
|
Re: Error getting native IReport object. This field name is not known.
Posted: 18 Mar 10 7:38 AM
|
Hi Parkin
Is that the only cause for occuring this error or any other causes also makes this error occurs. Because what i did was i have bundled the entire account table along with data and i have installed it again but it doen't works. More over i have a question is there any way we can find out in a saleslogix which field have been created from saleslogix and which field have been created from sql server mgmt studio. AS we are having numerous fields added i am not able to find out which field have been added from slx and which field from sql server
Thanks in advance
Mark
|
|
|
|
Re: Error getting native IReport object. This field name is not known.
Posted: 19 Mar 10 4:27 AM
|
Try running this to get a list of the non-SLX-generated fields:
select i.Table_Name, i.Column_Name
from sysdba.sectabledefs s
right join Information_Schema.columns i on s.Tablename = i.Table_Name and s.Fieldname = i.Column_Name
where s.tablename is null and i.Table_Name not in (Select Table_Name from information_schema.views) and
i.Table_Schema = 'sysdba'
I cannot guarantee that fixing these fields will resolve your problem, but if you do not fix them, your database is not supportable, so it is a necessary step.
If the problem persists after you have fixed up the fields, we'll try something else.
|
|
|
|