Although Job Was Running In Background Cancelled Due To Power Shut Down
Nov 5, 2007
Hi,
I am running two jobs background using SQL agent. There was a power shut down and the two job i was running in back groung were cancelled leaving the below message
The job was stopped prior to completion by Shutdown Sequence 0.
Can any one tell me why this happened although I am running them in back ground.
I am not sure where the servers are located and if they are located in the same bulding .. do u think it is bcoz of tis power shut down only?
If I start a long running query running on a background thread is there a way to abort the query so that it does not continue running on SQL server?
The query would be running on SQL Server 2005 from a Windows form application using the Background worker component. So the query would have been started from the background workers DoWork event using ado.net. If the user clicks an abort button in the UI I would want the query to die so that it does not continue to use sql server resources.
I'm calling a PHP page that run a stored procedure. The SP contains a xp_cmdshell command that runs a DTS package. This DTS package is HUGE and will take many hours to import tables from an Oracle database to SQL Server. But I don't want my PHP page to "hang" in the process...
How can I execute my PHP page and refresh it every 30 seconds to see if the importation is done ? In my actual code, I create a "start_file.txt" when I begin the importation and a "end_file.txt" when it's done. I want to refresh every 30 seconds to see if the "end_file.txt" is created and display a "Importation Done!" message.
To be able to do that, I need the DTS Package to run in the background of the web server, or asynchronously from my PHP page.
Simple (stupid) question: is it possible to create a SP to call my main SP so it will run independently ??
Let's review some of my code here.
Part of my PHP page: $DTS_result = $dbj->Execute(mssql_query("EXECUTE Run_DTS_Packages"));
My Stored procedure (without username & password...): CREATE PROCEDURE Run_DTS_Packages AS exec master.dbo.xp_cmdshell 'C:Progra~1Micros~380ToolsBinnISQL.EXE -S RHEA -U user -P pwd -Q "ISQL_Batch ''D:DDFIImporteIMPICAFI.bat''" -n -d DDFI' GO
I tried below measure to get the YTD running product and its working fine for me. but I found one issue that its give me slow performance while I see running product by different dimension level.
I am running two jobs background using SQL agent. There was a power shut down and the two job i was running in back groung were cancelled leaving the below message
The job was stopped prior to completion by Shutdown Sequence 0.
Can any one tell me why this happened although I am running them in back ground.
I am not sure where the servers are located and if they are located in the same bulding .. do u think it is bcoz of tis power shut down only?
I am trying to show images in a product listing in power view.I work with an excel 2013 desktop version based on an office 365 pro account.I did the following steps:
import of an excel file with an article list via power query and loading the data to the data model import jpg images from a folder via power query, setting content as binary type and loading the data to the data modellinking both tables in power pivot--> manage via the image namesetting the table behavior for the images table under power pivot --> manage --> Advanced (e.g. Default Image: Content)opening power view and building article cards with article number and imageProblem: only a camera icon shows up in power view
Is there a solution with a desktop version?Can I use my Office 365 Pro account to make it work? How?Why is there no solution showing images in a pivot table?Link to Dropbox with power pivot files
I am looking to add a column to one of my tables that displays a running rank of how many times a customer has ordered in a given period.
I currently have such a column however this column ranks against ALL of the orders that a customer has placed and ignores filters, whereas I need one that ranks based on the filters that are active at any given time.
The current formula is:
CustOrderCountPersistant=RANKX(FILTER('Q1 Data Set',[k1_customer_id]=EARLIER([k1_customer_id])),[order_id],[order_id],1,DENSE)
For example, if I am looking at a full years worth of data and a customer has placed 10 orders in that period this formula will add a 1 in the column for first order, a 2 for the second and so forth all the way to 10, the last order.
However it will give me exactly the same results if I filter the data to just one month of that year where they may have order only 2 orders.
In this scenario I want to have another column with a table that is filter sensitive and would show 1 for the first order and 2 for the second order.
Now, I do understand that the issue here is probably the FILTER() I have on as, if I understand correctly, that means all other filters are ignored. My attempts at reworking the formula to remove this have been unsuccessful (such as using a CALCUALTE and trying to use filter properties within that forumula).
To explain the context - I want to create a measure that counts how many customers have placed x amount orders in y number of days e.g. how many customers have placed 2 orders in 30 days.
Creating a burn down chart using a running total of cumulative hours with the following formula:
CumulativeHoursLeft:=CALCULATE ( SUM('Projects'[Budget hours]) - SUM ( 'hours'[Hours] ), FILTER ( ALL ( 'hours'[Date] ), 'hours'[Date] <= MAX ('hours'[Date]) ) )
Works great except that in a Line Chart using [Date] as the Axis and CumulativeHoursLeft as the value, I get these spikes on days for which the employee reported no hours. I do know what exactly the measure is doing in this instance and I do not get this in a table, those dates simply do not appear. I have tried both Categories and Continuous for the Line Chart. I have also tried filtering where [Date] is not blank.how to get rid of the spikes?
I have several reports in a Power View Gallery. In Gallery view, most of the reports show the "Open New Excel Workbook", the "Create Power View Report", and the "Manage Data Refresh" buttons on the right side of the report list. Why would some reports not have these buttons available? In the attached image you can see one report with the buttons and one without the buttons.
I've imported a number of excel sheets into a Power Query Table. All seems to appear ok until I load the data. Of the 15k rows around 2k have a similar error where it cannot convert an integer to type string as below example
Expression.Error: We cannot convert the value 40 to type Text. Details: Value=40 Type=Type
The columns in question are all of integer type, I've looked through the M query and there is no conversion to string taking placeThe values where we don't get the error are also integers hence the intriguing question is why does the error occur on a subset and not the others. I suspect there is a limit to the number of errors also somewhere internally M query is converting the column to text for some reason.
Slow loading issue with an if statement. In the raw data the field [Location] is a text field e.g. 0010. I have a parameterised query that get a Location_Value from Excel and passes it to the PQ query using:
#"Filtered Rows1" = Table.SelectRows(#"Removed Other Columns", each ([SalesMode] = 0) and ([SalesType] = 0) and ([Location] = Location_Value))
This works fine if you chose a single location. However I wanted to be able to select all locations and text is horrible to work with so in PQ I used the change type function to change the location column into whole numbers. I changed excel to also pass a number as Location_Value. I was therefore surprised when the same query took 2.5 times longer to refresh????
My PQ now looks like this
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Location", Int64.Type}}), #"Filtered Rows1" = Table.SelectRows(#"Changed Type", each ([SalesMode] = 0) and ([SalesType] = 0) and ([Location] = Location_Value))
I'm wondering if I need to do something to the ([Location] = Location_Value) bit as maybe it still thinks [Loation] is text and it is trying to compare it to a number. I st assumed the step above meant that [Location] was now a number, but maybe you still have wrap it with some kind of VALUES or TEXT function?
Country State Rank India Kerala 1 India Kerala 2 India Kerala 3 India Tamil Nadu 1 India Tamil Nadu 2 India Orissa 1 India Orissa 2 US Florida 1 US Florida 2 US NewYork 1
I have to generate rank like this in power pivot. How can I achieve it?
Hi, I'm trying to transfer data from a DB2 database to a MS SQL Server database (approx. 150 000 rows).
When I execute the package, the process is always cancelled (In output window: SSIS package "DB2_test_TranAddl.dtsx" finished: Canceled.)
I use a view on DB2 to provide the data and I can modify it to return only a few rows. To achieve this, I use a WHERE clause: WHERE OUTLET_NO Between X And Y.
When I try OUTLET_NO Between 1 And 5 (255 rows) the package executes successfully. When I try OUTLET_NO Between 5 And 10 (388 rows) it works.
When I try OUTLET_NO Between 1 And 10 (643 rows) it fails!!
I have opened an account in [URL] and taken the 60 days trial for power bi pro. I've developed power pivot and generated power views in share point 2013. But, I'm new to Power BI desktop. I have created a report in power BI desktop and published to [URL]. Also, I have uploaded an excel file directly to [URL] and created the report from the workspace available there itself and pinned the report to dashboard also. Everything is fine till this. But, I need to refresh the file which I have uploaded. I have some dummy data in excel sheet.
ZipCode State ZipName
2345 AA AA 456 BB BB 6787 CC CC
This has been created as a table and then added to data model. So, power pivot has been created for the same. Then I have uploaded this file to [URL] site. But, I'm getting an error message while trying to schedule refresh for the same.
"You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model."
How can I create a data model connection? How can I schedule refresh for an excel file like this?
I'm a relative newcomer to Power View. I've been playing with charts and have been struggling to combine both line and bar on the same chart. It would appear this functionality is not available. Considering this is basic functionality when it comes to charting, how to achieve this....
I'm looking to replace text in a given column given a set of conditions in the other columns. Please see below the M query in the advance editor and in particular the bold text. Here I've created a new entry that would appear in the query applied steps window in the power query editor that I have called "Replace Values". The logic is if Data.Column4 column equals "London" then replace null values in Data.Column5 with London. However when I save the query below I get the error
Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?
I plan to change the expression to test for multiple conditions however I need to get the basic expression working first. The other frustration i had with the "if" statement is it had to have an else even though I didn't require it, am i doing something wrong here?
I have a queue that, after running fine for several days will mysteriously turn off. It doesn't seem to be related to a poison message because I can restart the queue and processing resumes just fine. What are all the scenarios that would cause a queue to turn itself off, so I can 1) take preemptive action to prevent it from happening in the first place and 2) respond appropriately when it occurs.
Also, how to properly setup and verify that the BROKER_QUEUE_DISABLED is working properly. This is the SQL that I have so far, but is there a more direct way to raise the event other than writing an activated stored procedure that rolls back 5 times?
I want to show on Power BI Dashboard a moving average - for example, I want to always show the last 30 measurement of body temperature but it looks like Power BI dashboard shows all measurements I have and compress them - which makes the dashboard ugly.
I tried to customize the X-axis properties but I dont know what I should change the default start/stop properties to (where the default property value is automatic).
I have scheduled a package "MyPackage" in a SQL Server Agent Job. It runs periodically with success. Sometimes the package status is shown as "Cancelled" what led me to assume some coincidences. So I took a look at the eventlog which contains the following message: Event Type: Information Event Source: SQLISPackage Event Category: None Event ID: 12290 Date: 30.01.2006 Time: 08:00:42 User: NT AUTHORITYSYSTEM Computer: MYSERVER Description: Package "MyPackage" has been cancelled.
I assume that the problem occurs when a user locally logs off from the Server where the SSIS-service is running.
Why does this happen? The Service runs under the local system account and so does the SSIS Job.
Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says:
Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas? Thanks! BobP
When attempting to update or delete data using Microsoft Access, this error often occurs. The data can be updated or deleted directly through SQL Server and the problem is not resolved by closing and restarting access. The tables accessed have primary keys.
Started a publication on a few tables, and decided to cancel it. Now there are no publications set up, but the sharing hand is still there on the database, and agents all over the place. Boss is angry, can I tidy up this mess?
I can't convince him I haven't made changes to the production database...
We are trying to build dashboards using Power BI desktop version with Power Pivot data model as a back end. To import the data to Power BI,we used Import ->Excel workbook contents option and successfully imported the model to Power BI .When I tried to refresh the Power BI,It's hitting the backend tables available in the power Pivot model. But my requirement is I need to refresh the Power BI from the power Pivot Datamodel(I'm expecting an option like Import from Power Pivot in Tableau).
One big reason why we have turned to Power BI for Office 365 is to share Power Pivot models with our senior executives who all use Macs.
While they have been able to successfully view the Power Pivot models and interact with the Slicers in Power BI, they have not been able to print the reports. We thought it was a Mac issue but it's happening on PCs too. There doesn’t seem to be a way to resize the report so that all columns print. So we then tried to click on the tiny button located in the bottom right corner that says “View Full-Size Workbook.” The file then opens up in Excel Online. Then when we click on the printer icon, we see the report but the slicer becomes invisible. When printing, all columns do show up however the slicer is invisible.
How to successfully print Power Pivot reports with slicers in Power BI?
I have 2 DB on SQL Server 7, that are synchronized by a continuous transactional replication. The tables have a primary key on an identity column. In order to avoid conflicts, the identities have different seeds, and increment equal to 10. When the server shuts unexpectedly, the current value for the identity column goes out of sync, that is it assumes the greatest value inserted. The workaround is to run DBCC checkident to correct the identity value.
The process winlogon.exe has initiated the shutdown of computer DOCSITE01FDK on behalf of user NT AUTHORITYSYSTEM for the following reason: Application: Maintenance (Planned) Reason Code: 0x84040001 Shutdown Type: shutdown Comment:
It tell you that the source is user23. Is there a way to determine who shut down this server?
BACKUP DATABASE [myDB] TO DISK = N'f:BACKUPSDailymyBKUP.bak' WITH NOINIT , NOUNLOAD , NAME = N'mybackup', NOSKIP , STATS = 10, NOFORMAT
It runs just fine but in append Mode (the default one); the bak file is being taped every night, so I would like to overwrite it, in order it not to become huge after a few time, but I can't seem to find a clear way to do this.
While tryign to edit the XML for the rdl , i am stuck it will not allow me to edit and i have to kill the devenv process and open vs again.
I looked through some of the threads and tried apply KB 936971 Hot Fix and I am running into the following error.
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch."
Did any one come across this. Any assistance would be greatly appreciated
I understand using sp_procOption procedure we could set procedure for autoexecution every time an instance of SQL Server is started. I would like to find out if there is any way for me to run a procedure before server shuts down.
I am interested to collect statistical data from DMV before SQL Server is restarted due to DMV's transient nature. I am sure some of you would suggest having a job running that collects data from DMV's periodically. But ideally I would like to collect data only once for server uptime.
