This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Have you guys encountered the following error when pulling out item data through SQL Management Studio?

```The OLE DB provider "MSDASQL" for linked server "NETSUITE" supplied inconsistent metadata for a column. The column "autoexpandkitforrevenuemgmt" (compile-time ordinal 7) of object ""Company"."SuiteAnalytics Connect Role"."item"" was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0 at compile time and 128 at run time.```
Query:
```SELECT id FROM [NETSUITE].[Company].[SuiteAnalytics Connect Role].[item]
WHERE id = 2732```
Sometimes it throws:
```The OLE DB provider "MSDASQL" for linked server "NETSUITE" reported an error. The provider ran out of memory.```

Try run through Open Query instead... ?

SELECT * FROM OPENQUERY ([NETSUITE],  'SELECT * FROM Item where id= 2732   '  )

...or maybe don't do select * ....    only select the columns you need...   doyou need the data for "autoexpandkitforrevenuemgmt"  ?