Skip to main content

Unanswered questions

11 Topics
L
leoarthurNewcomer
asked in CData Arc
Best Practices for Optimizing CData Data Connectors with Intel Arc GPUs

Hi everyone,I’m currently working on a project that involves using CData data connectors with Intel Arc graphics cards. I want to ensure that I’m getting the best performance and efficiency out of this setup. Could anyone share best practices for optimizing CData data connectors specifically when using Intel Arc GPUs?Best Practices:Update Drivers: Ensure that both Intel Arc drivers and CData connectors are up to date to benefit from the latest performance improvements and bug fixes. Adjust Connection Settings: Configure CData data connectors to utilize multi-threading options if available. This can enhance performance, especially with the parallel processing capabilities of Intel Arc GPUs. Monitor GPU Usage: Use Intel's performance monitoring tools to check if the GPU is being fully utilized. Adjust settings in CData to match the GPU’s performance profile. Optimize Data Queries: Design efficient queries and avoid over-fetching data to reduce processing load. This helps in balancing the

0
L
1 hour ago
L
loisine.ann.mendozaCollaborator
asked in CData Sync
The SQL Error Number is 102, State is 1, Severity is 15, Error is 'Incorrect syntax near 'f8a8d2f'.', Server name is AWDAPPINDB3, Line number is 1.The Token Type is 170

:45:17.636-06:00  1  [42|Q-Id]  [META|Schema] Executed  column schema query: [App_History] Success: 4 results (268 ms)2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table] Success: (268 ms)2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Parsed] Executing query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Parsed] Parameter: pk_b0 = 0f8a8d2f-1266-4f33-86ed-0d94f446125c2024-09-10T21:45:17.636-06:00  5  [42|Q-Id]  [META|Schema] Engine Invalid object name 'App_History'2024-09-10T21:45:17.636-06:00  3  [42|Q-Id]  [TCP |Send  ] Send Begin - Length: 2742024-09-10T21:45:17.636-06:00  5  [42|Q-Id]  [TCP |Send  ] [SQL |Messag] Query Failed: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]. Error: The SQL Error Number is 102

7
D
2 days ago
P
PradeepApprentice
asked in CData Arc
Prod Flag - EDIFACT Connector

When I use the EDIFACT connector for sending the outbound EDIFACT messages, there is option to enable to include Test Indicator, thus it include “1” as test indicator at UNB 11.UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIP:ZZZ+9500SCJID:ZZZ+240913:0829+000000007++INVRPT++++1'UNH+0002+INVRPT:D:98B:UN' Once we move the code to Production environment, I have to disable the Test Indicator since this is Prod files, but the UNB11 dosen’t populated with “0”. UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIT:ZZZ+9500SCJIDTEST:ZZZ+240913:1140+000000186++INVRPT'  à missing the Prod Flag “0”.UNH+121+INVRPT:D:98B:UN'  Please advise is there any option I could be able to populate the Prod Flag.

2
Chaitanya Sandra
2 days ago
L
loisine.ann.mendozaCollaborator
asked in CData Sync
Name Tool ID# not found inside D at [1:97]

2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Cache ] Cache failed: [500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]2024-09-10T00:52:03.708-06:00    0    [6|Q-Id]    [SQL |Cache ] Replication Failed. Error:[500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:System.Data.CData.SQL]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:GoogleBigQuery]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:SQLite]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [tools_data_testing] WITH _id = '5a2DAIBt+eVwYnh0y2b6zA==' SELECT [Access Method] AS [access_method], [Actively Selling] AS [actively_selling], [Actual Deployment Date] AS [actual_deployment_date], [Additional Languages] AS [additional_languages], [AKA N

3
L
3 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Reason for ID change in Reporting Balance

5 days back  I get rows from Reporting balance and stored in one excel again I fetch same rows from reporting balance but i noticed that ID is changed for some rows Eg :228473716 where previously for one row but the same row ID is differed now like 2284765654Based on GLAccountCode Division and Reporting year I am fetching the rows any reason for this ? how to track this which row is changed ?Thanks

2
M
4 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Deleted Reporting Balance Row Track

How to track which reporting balance row is deleted? because I am syncing record through Power automate. I am not able to track which row is deleted in reporting balance. if i get to know about that transaction I will sync that particular row related records again I am using cdata cloud

0
M
4 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
GLSchemeCode Change track

I have GL Account Classification Mapping In Dataverse Table i used automation to pull data from Exact online and pushed data into dataverse . I need help on how to track that GLSchemeCode Changes from previous version  to updated version Eg:RGS versie 3.3 to RGS versie 3.5 in overtime because based on this updation in exact online I want to update the same thing in dataverse table  how to track this change and update accordingly ?

1
Ethem Q
18 days ago
S
steven.hicksApprentice
asked in CData Sync
Sage Intacct Sync: tables vs views

We are currently implementing CData to sync to a data warehouse. I’m not non-techy guy on the team and we’re trying to figure out the tables and views that are listed in the Sage Intacct Connector for CData Sync - Data Model.Are these the only tables/views available? Also, what’s the different between a table and a view? Why would a Gldetail and Glentry view, which should have the same columns, be different?Thanks!Steven

1
Ethem Q
19 days ago
J
JTapioApprentice
asked in CData Sync
Post-job event to send email if job finishes 0 rows

I’d like to get information if certain job finishes successfully, but 0 rows are replicated. I found snippet that send email, but how can I write an “if query” that catches only  those scheduled jobs that I want? There is snippet template for that, but I don’t understand how it need to be modified <!-- Enumerate Through Query Results --><api:enum prefix="Query#"><api:set attr="temp.index" value="[_index]" /><api:set attr="temp.query" value="[_value]" /><api:set attr="temp.status" value="[QueryStatus#[_index]]" /></api:enum>  

4
J
20 days ago
C
ColdTrackTomApprentice
asked in CData Virtuality
GoogleSheets datasource setup

Looking for config details for the google sheets connector within DataVirtuality.  I’m getting the error below:  This app is blockedThis app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.

0
C
23 days ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Check GLAccountCode linked with Division

from which table we can check what are GLAccount code linked for a particular Division ? 

1
Ethem Q
1 month ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings