cancel
Showing results for 
Search instead for 
Did you mean: 

BODS Rapid mart error

md_fasi
Participant
0 Kudos

Dear Friends,


We have cost center rapid mart which is running since from long 24 hours(earlier it takes 14 hours) after that it has got ended with following error


<//pthmssap01p01....local/trans/COTransFact.dat>. The row delimiter should be seen after <58> columns. Please check the file for bad data,


or redefine the input schema for the file by editing the file format in the UI.

(12.2) 12-19-13 12:41:30 (W) (12276:12712) FIL-080105: |Data flow DF_CostTransactionFact_SAP|Embedded Dataflow EDF_CostTransactionFact_SAP|Reader EID_2_R3_CostTransactionFact

A row delimiter was seen for row number <1768468> while processing column number <5> in file

                                                       <//pthmssap01p01....local/trans/COTransFact.dat>. The row delimiter should be seen after <58> columns. Please check the file

for bad data, or redefine the input schema for the file by editing the file format in the UI.

(12.2) 12-19-13 13:23:24 (E) (3352:11664) SYS-170106: |Data flow DF_CostSummaryFact_SAP|Transform OrderByQuery

Cannot write onto Disk for the file <D:\Program Files\Business Objects\BusinessObjects Data

Services\log\PCache/pth-sapsql03_bormdsp_bormdsp/6505284235201Sort24_3352_1>. OS Error: <No space left on device>

(12.2) 12-19-13 13:23:24 (3352:11664) SYS-170105: |Data flow DF_CostSummaryFact_SAP|Transform OrderByQuery

(12.2) 12-19-13 13:23:35 (12088:12524) SYS-170105: |Data flow DF_CostSummaryFact_SAP|Transform OrderByQuery

I need to clarify few points.

1. A row delimiter was seen for row number <1768468> while processing column number <5> in file

     When I check the details (source & Target) I found only 3000 records.Then how this row number <1768468>

     can be available


2.Cannot write onto Disk for the file <D:\Program Files\Business Objects\BusinessObjects Data

Services\log\PCache/pth-sapsql03_bormdsp_bormdsp/6505284235201Sort24_3352_1>. OS Error: <No space left on device>

When I checked the path I can found 2.76 GB already available.Then iam unable to understand which it is showing <No space left on device>


3. please check file for the bad data or redefine input schema

     Please show some light on this point.


Environment Source ECC > BODS 3.2(Rapid marts 3.2) >SQL Server 2008 >Webi


Please do the needful


Thanks in advance


Thanks & Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

md_fasi
Participant
0 Kudos

Hi,

After raising  this error with SAP, SAP has suggested to open the .DAT file at SAP server  validate and remove the errors.

I tried opening the file.But due to huge number of records it is not allowing to open the file(in notepad)

Do any one have idea of opening the ,DAT file apart from Notepad

And let us know if there is any other way to resolve this error

Thanks & Regards,

Fasi

former_member187605
Active Contributor
0 Kudos

There seems to be a contradiction in your saying you "found only 3000 records" in the input file on one side, and the 1768468 records in the error message and the huge file size on the other side.