Prev: Datastep question
Next: PROC IMPORT for multiple txt files
From: sasuser sasuser on 15 Apr 2010 04:28
Hi,

I am trying to export data sets from server to local pc using the
export function in EG. For some of the data sets, I get the "The
parameter is incorrect" error. The following is the log.

My EG is version 4.1 and updated with the latest hot fix 14. Some of
the data sets is as large as 1.5 GB and some as small as 100 MB. I
have also tried using "Download Data Files to PC" plugin. This plugin
managed to download the data but the encoding is in native of the
server, which is unix and the client tool that I am using, cannot read
the data sets (Cross Environment Data Access error).

Can anyone help? How to resolve this? Or any other way to download
data to local pc?

File To Export:
testdata

Output File Type:
SAS Data File (*.sas7bdat)

Options:
Use labels for column names : False

Output File:
E:\testdata.sas7bdat

Total Processing Time:
170.9063 seconds

Error:
Attempt 3 : The parameter is incorrect.
at SAS.IDataSet.AddRecords(Int32 BindKey, Array& NumericValues,
Array& MissingNumericValues, Array& CharacterValues, Array& Bookmarks,
Int32& Status)
at SAS.EG.DataAccess.DataModel.DaForSasData.AddNewRecords(Object[,]
a_arColValues)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String
a_strTargetServer, String a_strActiveDataSource, DataSourceManager
a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints, String dateTimeFormatString)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName
openName, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection
project, ICanBeInputData sourceData, OpenName rawDestination, Boolean
useLabelsAsColumnNames, Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on,
Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable
iExportable, OpenName on, Int32 tryAgain)
Attempt 2 : The parameter is incorrect.
at SAS.IDataSet.AddRecords(Int32 BindKey, Array& NumericValues,
Array& MissingNumericValues, Array& CharacterValues, Array& Bookmarks,
Int32& Status)
at SAS.EG.DataAccess.DataModel.DaForSasData.AddNewRecords(Object[,]
a_arColValues)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String
a_strTargetServer, String a_strActiveDataSource, DataSourceManager
a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints, String dateTimeFormatString)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName
openName, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection
project, ICanBeInputData sourceData, OpenName rawDestination, Boolean
useLabelsAsColumnNames, Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on,
Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable
iExportable, OpenName on, Int32 tryAgain)
Attempt 1 : The parameter is incorrect.
at SAS.IDataSet.AddRecords(Int32 BindKey, Array& NumericValues,
Array& MissingNumericValues, Array& CharacterValues, Array& Bookmarks,
Int32& Status)
at SAS.EG.DataAccess.DataModel.DaForSasData.AddNewRecords(Object[,]
a_arColValues)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String
a_strTargetServer, String a_strActiveDataSource, DataSourceManager
a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints, String dateTimeFormatString)
at
SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName
openName, Boolean useLabelsAsColumnNames, Boolean
copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection
project, ICanBeInputData sourceData, OpenName rawDestination, Boolean
useLabelsAsColumnNames, Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on,
Boolean CopyIntegrityConstraints)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable
iExportable, OpenName on, Int32 tryAgain)
 | 
Pages: 1
Prev: Datastep question
Next: PROC IMPORT for multiple txt files