BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

File currupt and cannot open(FRM0003)


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
ashvini
Senior Member
Senior Member



Joined: 01 Feb 2007

Posts: 44



PostPosted: Mon Jul 28, 2008 11:09 am 
Post subject: File currupt and cannot open(FRM0003)

Hi All,

I am getting the above error when I export any document into repository and then try to import it.

I have done following things
1>This is not user specific or machine specific
2>I purged the report before exporting
3>I deleted the currupt files and tried again
4>I renamed the report and export it
5>I did Scan and repair and tried it again.
6>I tried installing and uninstalling BO
7>Previously there was a virus on system but we cleaned the files but still same error.

The export is always successful but when we tried to import it its giving me issues.

Please could any body have any clue.

Its a production issue and its quite urgent.

I dont know what else to try banghead.gif

Thanks in advance

Ashvini
Back to top
JohnCW
Principal Member
Principal Member



Joined: 05 Aug 2004

Posts: 204
Location: Cheese-land


flag
PostPosted: Mon Jul 28, 2008 3:03 pm 
Post subject: Re: File currupt and cannot open(FRM0003)

Can you tell us what version, Service Pack, HotFix, etc. that you are on.

When you save it are you selecting the check box "Save for all users"?
Back to top
ashvini
Senior Member
Senior Member



Joined: 01 Feb 2007

Posts: 44



PostPosted: Tue Jul 29, 2008 3:25 am 
Post subject: Re: File currupt and cannot open(FRM0003)

Sorry for not providing all information.

We have BO 6.5 SP4 and I dont click the check box Save for all users.

This problem has started to come only 2 days back. Previously everything was working fine.
Back to top
looksmee
Forum Addict
Forum Addict



Joined: 08 Feb 2006

Posts: 2674
Location: Manchester


flag
PostPosted: Tue Jul 29, 2008 4:43 am 
Post subject: Re: File currupt and cannot open(FRM0003)

ashvini wrote:

I am getting the above error when I export any document into repository


Hi Ashvini

Will you be able to open the report or your getting the error message while export the report..? This looks like your report file has deleted from the repository and your trying to export the local copy of your report in the repository. If its the case, its not possible to open the report.

Posting the more detail will help us to keep you update.

Regards

Siva.M
Back to top
JohnCW
Principal Member
Principal Member



Joined: 05 Aug 2004

Posts: 204
Location: Cheese-land


flag
PostPosted: Tue Jul 29, 2008 9:05 am 
Post subject: Re: File currupt and cannot open(FRM0003)

We used to have this problem as well. However, it began shortly after migrating to XI R2 SP1.

You might want to try checking the "save for all users" box...that sometimes helped. In the end though, tech support created a hotfix which resolved the problem. There were 3 .dll files that they had to repair.

The problem may have started in 6.5 though...not sure why it was not consistent. If the "save for all users" is not satisfactory, you may want to contact tech support to see if they created some type of patch for the 6.5 environment.
Back to top
mirko
Principal Member
Principal Member



Joined: 21 Aug 2002

Posts: 117
Location: belgium



PostPosted: Wed Jul 30, 2008 1:02 am 
Post subject: Re: File currupt and cannot open(FRM0003)

are you sure you're not overlooking anything at the level of ODBC ? we encountered this problem in the past in a DB2 environment (iSeries), where it turned out to be a setting in ODBC regarding binary file handling.


good luck,
mirko
Back to top
ashvini
Senior Member
Senior Member



Joined: 01 Feb 2007

Posts: 44



PostPosted: Wed Jul 30, 2008 11:40 am 
Post subject: Re: File currupt and cannot open(FRM0003)

Hi Mirko,

Thanks for the tip. This made me look into the ODBC.sbo file. We have recently added new parameter for SQL server as <Parameter Name="Force SQLExecute">Always</Parameter>

and now to think back after this change was made I am getting this error. We need this parameter to run few SPs through BO.

Has anyone ever added this parameter and any solution to solve my existing issue and keep this parameter as well?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0281 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0244)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo