noreply@blogger.com (Gurjeet Singh)Thu, 27 Aug 2026 09:34:42 +0530Blogger http://www.blogger.com395125http://j4info.blogspot.com/en-usnonoreply@blogger.comhttp://j4info.blogspot.com/2023/12/sql-server-ssms-stuck-on-query-while.htmlSqlserver DML and Functionsnoreply@blogger.com (Gurjeet Singh)Thu, 7 Dec 2023 20:22:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-1618674144015454221 I was going to truncate a table in sqlserver database but it seems to be went in deadlock. Apart from this if issue persist regularly then use delete command instead of truncate command.List of DeadlockSELECT    SESSION_IDFROM SYS.DM_EXEC_REQUESTSWHERE BLOCKING_SESSION_ID != 0Kill the deadlock:kill SESSION_ID0http://j4info.blogspot.com/2023/12/create-sequence-using-sql-in-mysql.htmlmysqlnoreply@blogger.com (Gurjeet Singh)Thu, 7 Dec 2023 19:20:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-2296914680752228439Generate a range of consecutive/Sequence numbers (1 to 100)  using a MySQL query, see below. Replace 100 number as per your choice, so it will generate sequence of numbers 1 to number you will going to replaceselect t0.rn+t1.rn+t2.rn+t3.rn  as Sequencefrom    (select 0 rn union select 1    rn union select 2 union select 3 union select 4 union select 5 union0http://j4info.blogspot.com/2023/08/sql-server-blocked-access-to-procedure.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Wed, 23 Aug 2023 22:13:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-4484569171074886513SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.SolutionEXEC sp_configure '0http://j4info.blogspot.com/2023/08/driver-class-orggjtmmmysqldriver-could.htmlmysqlpentahonoreply@blogger.com (Gurjeet Singh)Wed, 23 Aug 2023 22:12:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-2214230602401715200Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm.mysql.DriverIssue : Creating connection with MySQL with kettle, was using Data Integration Kettle version 9.0Mysql Driver version 8.0.25ErrorDriver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. 0http://j4info.blogspot.com/2023/07/alter-table-statement-conflicted-with.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Sat, 1 Jul 2023 17:44:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-7589352123689263552Server Type - MS SQL  Server Scanerio : Error faced when tried to apply foreign key constraint on table having data in it (non empty table).ErrorMsg 547, Level 16, State 0, Line 20 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "". The conflict occurred in database "", table "dbo.", column '**'SolutionEmpty table first then apply foreign key  0http://j4info.blogspot.com/2023/05/dividing-number-return-zero-postgres.htmlPostgresnoreply@blogger.com (Gurjeet Singh)Tue, 16 May 2023 14:54:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-3602802462629965553 If you are also facing same issue, here is solutionEARLIERselect (15/20)  Output0NOWuse this command to get correct output in postgres select (15/20::float)::numeric(5,2)Output 0.75  you can Also  create function in databaseCREATE OR REPLACE FUNCTION dvdrental1(part int, fullv int) RETURNS float AS $$BEGIN  RAISE NOTICE 'PROGRESS IN PERCENT : %', (part/fullv::0http://j4info.blogspot.com/2023/05/postgres-dvdrental-sample-database.htmlPostgresnoreply@blogger.com (Gurjeet Singh)Tue, 16 May 2023 14:05:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-4932486954682619901I was facing error while restoring the database dvdrental for postgres. Postgres 9 was installed on my machine and connect as postgres user with database postgres.First i tried to execute restore.sql script using pgadmin sql executor and throw below error: ERROR:  syntax error at or near ''\''LINE 35: \connectSOLUTIONSQL need to execute on CMD, so open CMD and move to postgres installation 0http://j4info.blogspot.com/2023/02/find-deadlock-query-and-kill-process-in.htmlPostgresnoreply@blogger.com (Gurjeet Singh)Tue, 14 Feb 2023 17:39:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-5038718306955115184If your query took longer and never ending then possibility tables are under deadlock. You can easily identify the deadlock in postgres and kill the lock.SELECT * FROM pg_locks pl LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid where state= 'active'    Find the records which are under deadlockselect     pid, state, usename, query, query_start from    &0http://j4info.blogspot.com/2022/09/py0024-python-error-while-reading-csv.htmlPythonnoreply@blogger.com (Gurjeet Singh)Fri, 2 Sep 2022 22:25:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-6973666052670784660 Python error, while reading CSV fileimport pandas as pdf = 'C:\\Users\\*****\\Desktop\\Emp.csv'from datetime import datetimecustom_date_parser = lambda x: datetime.strptime(x,"%d-%m-%Y %H:%M:%S")df = pd.read_csv(f,nrows=100,parse_dates=True,date_parser=custom_date_parser)df.info()During handling of the above exception, another exception occurred:Traceback (most recent call last):  File0http://j4info.blogspot.com/2022/09/dbvisualizer-not-starting-after-install.htmldb Toolnoreply@blogger.com (Gurjeet Singh)Fri, 2 Sep 2022 22:21:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-1258354805735270700 I have installed DB-visualizer on windows machine, after installation when i click icon to launch application it wont launch. I checked event viewer nothing appear. Then i tried to launch application using CMD and got below error.Error:Don't set the -Xmx property too large as it may result in Java not being able to launch DbVisualizer properly. If you experience problems starting 0http://j4info.blogspot.com/2022/08/mysql-error-this-function-has-none-of.htmlmysqlnoreply@blogger.com (Gurjeet Singh)Wed, 31 Aug 2022 17:29:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-215225121923927949 Error while executing script in MYSQL workbenchErrorError Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)SolutionExecute the below Command in the MySQL console or Workbench:SET GLOBAL log_bin_trust_function_creators = 1; For 0http://j4info.blogspot.com/2022/08/open-office-writer-table-of-index.htmlofficenoreply@blogger.com (Gurjeet Singh)Fri, 26 Aug 2022 16:25:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-9105269995576333014 How to Enable Hyperlink in Index Table. You must have a Open office writer with content and make sure content is marked as Heading 1, Heading 2 , Heading 3,.... Heading n  Next Add Index table Go to  Insert > Table of Contents and Index >  Table of Contents and Index or bibliographyIndex will be added, and you may noticed no hyperlink on index data. Now 0http://j4info.blogspot.com/2022/08/ora-39001-ora-39000-ora-31640-ora-27041.htmlOraclenoreply@blogger.com (Gurjeet Singh)Wed, 10 Aug 2022 13:17:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-1296866244178477349impdp Scott/tiger full=Y directory=data_pump_dir dumpfile=scott.dmp TABLE_EXISTS_ACTION=SKIP SKIP_UNUSABLE_INDEXES=y EXCLUDE=STATISTICS DATA_OPTIONS=skip_constraint_errors  REMAP_SCHEMA=old_schedma_in_dmp:scott logfile=data_pump_dir:scott_full_094358_1.log EXCLUDE=GRANTAfter executing above command received error :ORA-39001: invalid argument value ORA-39000: bad dump file specification 0http://j4info.blogspot.com/2022/08/cmd-code-to-copy-files-from-1-folder-to.htmlBatchnoreply@blogger.com (Gurjeet Singh)Fri, 5 Aug 2022 11:46:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-2696688579127388770 requirement : Here i have scenario like i have all the files name or image name which i need to copy over to new directory in same computer or on any external drive.Code@echo offSETLOCAL ENABLEEXTENSIONS ENABLEDELAYEDEXPANSIONSET "source=D:\srcdir\"SET "source1="D:\srcdir""SET "destination=D:\Destination"SET "FileNameFromTExtFile=.\Path1.txt"if not exist "D:\Destination\" mkdir D:\0http://j4info.blogspot.com/2022/08/cmd-copy-folder-structure-only.htmlBatchnoreply@blogger.com (Gurjeet Singh)Fri, 5 Aug 2022 11:29:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-8540688485381766211Command to copy the folder structure on disk drive without copy the files on cmdD:\Source>XCOPY "D:\Source" "D:\MyDrive" /t /eDoes D:\Source specify a file nameor directory name on the target(F = file, D = directory)? After execution of command CMD will ask to enter A or D.Give Input A if you would like to add output in file and D if you would like create directories.This command will 0http://j4info.blogspot.com/2022/06/sql-server-database-in-single-user-model.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Mon, 6 Jun 2022 15:49:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-8536261989307849869 Some time you may have notice database status change to "Single User", Once database status changed to "single user" you will not be able to execute query on that database. Below is the solution to change the status of database to "MULTI_USER"Solution :SELECT request_session_id, * FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID('databaseName') Connect to Master database or any 0http://j4info.blogspot.com/2022/05/kettle-there-was-data-type-error-data.htmlpentahonoreply@blogger.com (Gurjeet Singh)Fri, 27 May 2022 13:53:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-489775493225089833: Errors detected!: Because of an error, this step can't continue:: org.pentaho.di.core.exception.KettleValueException: ********** BigNumber(15) : There was a data type error: the data type of java.lang.Long object [5061] does not correspond to value meta [BigNumber(15)]at org.pentaho.di.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:1927)at org.pentaho.di.core.row.RowMeta.getString(0Chandigarh, India30.7333148 76.7794179-24.767750189723206 6.4669178999999986 86.2343797897232 147.0919179http://j4info.blogspot.com/2022/05/local-task-bar-appear-when-remote.htmltips and tricksnoreply@blogger.com (Gurjeet Singh)Thu, 12 May 2022 14:19:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-5779050402474223070You may appear the local machine Task Bar overlap on Remote machine task bar when operating remote desktop in full screen mode (mstsc).To avoid this Problem just restart the services of Explorer of local machine will fix your problem.Open you task manager from local machineLocate the "windows explorer" under Process tab.Right click and Restart services0http://j4info.blogspot.com/2021/10/the-certificate-is-not-valid-and-cannot.htmlnoreply@blogger.com (Gurjeet Singh)Wed, 6 Oct 2021 23:01:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-2856960025461120078 I was working of oracle apps which was working fine for. One day Suddenly i was unable to launch application.Note Application was using Java to launch.Do you want to Continue?The connection to this website is untrusted.Note the certificate is not valid and cannot be used to verify the identity of this website.More Information:The certificate used to identify the website is not trusted. The 0http://j4info.blogspot.com/2021/10/oracle-database-impdp-error.htmlOraclenoreply@blogger.com (Gurjeet Singh)Wed, 6 Oct 2021 22:13:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-2051402581986604127Error:import done in AL32UTF8 character set and AL16UTF16 NCHAR character setexport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setWarning: possible data loss in character set conversionsStarting "*DatabaseName*"."SYS_IMPORT_FULL_01":  *DatabaseName*/******** DIRECTORY=MYDIR DUMPFILE=BackupName.DMP LOGFILE=BackupName.log PARALLEL=8 remap_schema=OldDBName:NewDbName 0http://j4info.blogspot.com/2021/10/error-while-inserting-record-in.htmlSalesForcenoreply@blogger.com (Gurjeet Singh)Wed, 6 Oct 2021 22:10:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-7780203721424130886Error:INVALID_FIELD_FOR_INSERT_UPDATE Error message: Unable to create/update field  Please check the security settings of this field and verify that it is read/write for your profile or permission.Solution:remove the fields from migration which are mentioned in above errorcause those fields will be populated automatically by salesforce (while migration)field data type may be "auto generate" 0http://j4info.blogspot.com/2021/08/function-identify-special-character-and.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Sat, 7 Aug 2021 20:31:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-5862247913507022007 Create function in sqlserver to identify the special character in string ( in parameter), and it will replace all the special character with "AND". You can modify the function as per your requirement and can replace it with space.DROP FUNCTION func_Gen_str CREATE FUNCTION Func_Gen_str (@NewStr VARCHAR(1000)) RETURNS VARCHAR(1000) AS BEGIN DECLARE @newstring VARCHAR(1000) = @NewStr; 0http://j4info.blogspot.com/2021/07/ssms-sql-server-management-studio-close.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Mon, 12 Jul 2021 21:20:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-8674271951073184738SSMS SQL Server Management Studio, close automatically when executed Larze size query in Query Window.It donot give any warning, just close all the opened query window, even it will not ask you to save the open Query WindowI traces the Error from Events: see below:Faulting application name: Ssms.exe, version: 2011.110.2100.60, time stamp: 0x4f35e2d9Faulting module name: 0http://j4info.blogspot.com/2021/05/search-string-in-sqlserver-in-all.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Tue, 25 May 2021 19:38:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-7675034333500976091 Search String in SQLServer in All databases all tables all columns  -------------------------Part 1--------------------------Part 1 --------------------------Part 1USE [master]GOcreate/alter PROC [dbo].[GlobalSearch]ASBEGIN IF OBJECT_ID('dbo.ListOfObj', 'U') IS NOT NULL DROP TABLE dbo.ListOfObj; CREATE TABLE master.dbo.ListOfObj (DatabaseNAME nvarchar(370), 0http://j4info.blogspot.com/2021/05/sql-server-installation-error.htmlSqlservernoreply@blogger.com (Gurjeet Singh)Mon, 17 May 2021 22:16:00 +0530tag:blogger.com,1999:blog-8712796563830044532.post-3268168928269935190 TITLE: Microsoft SQL Server 2012  Setup------------------------------The following error has occurred:Error while enabling Windows feature : NetFx3, Error Code : -2146498220 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features , see http://go.microsoft.com/fwlink/?linkid=227143For 0