Copy Job from on prem SQL to Fabric SQL Database Error
Hi there Fabric Experts. I am trying to copy data(using Copyjob) from SQL on prem to fabric SQL database. My connection works just fine and I can connect to the datasource,view the tables, select incremental column and select my Fabric SQL as a destination(the fabric SQL database exists in the same workspace). However when I run the copyjob it fails with the below error: Fabric activity failed. ' Error occured while trying to get FabricSqlConnectionInfo. Please retry later. Detailed Message: 'StatusCode: NotFound, WorkspaceId: myid, ArtifactId: sqlID, Error Code: ItemNotFound, Message: Could not found the requested item,"errorCode":"ItemNotFound","message":"Could not found the requested item"}' '. Note, ids are masked due to security. It seems to not be able to find the Fabric SQL database although it's created and I can select it as my destination on the CopyJob UI. I can also view and query the Fabric SQL database perfectly from the workspace. The Copyjob just does not seem to find it while running. My aim is to use Fabric Translytical Task flows to update data on Fabric SQL based on the inital load. Is this a known issue? Appreciate any help on it. Thanks
Fabric SQL DB critical CI/CD sync issue
I have a SQL DB inside a fabric workspace and I am setting it up for CI/CD using GitHub. But any sync made via the repository fail when syncing to the workspace. Here are the steps I do: The SQL DB was created within the fabric workspace and the SQL DB works fine on fabric service SQL DB is commited to my repo via the worksapce source control pane I make a simple change to a SQL query via git in the repository I update the workspace items based on the repository changes I get this error: SQL Project build failed. The model version 'SqlDbFabric' is not supported. The model version 'SqlDbFabric' is not supported. And even if I don't make any changes to the repo I get the error: The SQL DB was created within the fabric workspace and the SQL DB works fine on fabric service SQL DB is commited to my repo via the worksapce source control pane I create a new blank workspace in fabric I sync the workspace with the same branch from my repo that I commited in step 2, basically getting the items from the repo to the workspace I get this error: SQL Project build failed. The model version 'SqlDbFabric' is not supported. The model version 'SqlDbFabric' is not supported. Is fabric not cabaple of rebuilding the SQL DB from its own created files? Because the documentation says otherwise. Here is the .sqlproj code autogenerated by fabric: <?xml version="1.0" encoding="utf-8"?> <Project DefaultTargets="Build"> <Sdk Name="Microsoft.Build.Sql" Version="2.1.0" /> <PropertyGroup> <Name>ACTIVITIES_SQL_DB</Name> <ProjectGuid>{00000000-0000-0000-0000-000000000000}</ProjectGuid> <DSP>Microsoft.Data.Tools.Schema.Sql.SqlDbFabricDatabaseSchemaProvider</DSP> <ModelCollation>1033, CI</ModelCollation> </PropertyGroup> <ItemGroup> <PackageReference Include="Microsoft.SqlServer.Dacpacs.DbFabric"> <SuppressMissingDependenciesErrors>False</SuppressMissingDependenciesErrors> <DatabaseVariableLiteralValue>master</DatabaseVariableLiteralValue> <Version>170.0.0</Version> </PackageReference> </ItemGroup> <Target Name="BeforeBuild"> <Delete Files="$(BaseIntermediateOutputPath)\project.assets.json" /> </Target> </Project>
Error Mirroring to Fabric: The error is: Exception reading the data file.
I am replicating data from an Oracle 19c database to a mirrored database in Fabric. All Oracle tables are successfully replicating, but I'm getting the same error message on two tables. Neither table has a NVARCHAR(MAX) column (as I've heard this causes issues). Here's the schema of one of the failing Oracle tables and the actual error message is below. lineitemamt number lineitemusage float adddttm date moddttm date paidstat nvarchar2(1) pendflag nvarchar2(1) pendtype nvarchar2(1) lineitemkey number billkey number lineitemunits float addby nvarchar2(30) modby nvarchar2(30) penaltypayorder number principalpayorder number printtext nvarchar2(300) discountexpiredate date commentskey number lineitemsetupkey number penaltydate date penalizedflag nvarchar2(1) accountservicekey number printorder number legacylineitemno number actualamt number budgetedamountflag nvarchar2(1) variantflag nvarchar2(1) Table (subtask 0 thread 1) is suspended. The Fabric Mirrored database indicate an error, errorStatus: 'Replicating', errorCode: '', errorMessage: 'We encountered an error while parsing data file being used, please fix the file and try again. The error is: Exception reading the data file. Exception: No data rows available. Appreciate any suggestions, tips. ThanksAzure SQL db issue: Reference to database and/or server name is not supported in this version of SQL
Hi All, I've two views in two different Azure SQL database: [dbo].[view1] in DB1 [dbo].[view2] in DB2 both DB1 , DB2 is in the same server. I need to join these two views. When i ran the select query it is throwing the below error: Msg 40515, Level 15, State 1, Line 30 Reference to database and/or server name in 'DB2.dbo.view2' is not supported in this version of SQL Server. This is my select query: select top 10 * from [DB1].[dbo].[view1] t left join [DB2].[dbo].[view2] cr on t.InternalGTECode = cr.New_Engagement_Mirror_Code i tried to run this query in both db as well as the master db.. but getting the reference error. Please help