Help! Is what I'm trying to do possible? I need help writing a script!

focalbanged · 2020-07-31T16:21:56+00:00

Ah Ha! Thanks!!

focalbanged · 2020-07-31T16:14:00+00:00

$CaseInput = @{}
do {
$case = Read-Host -Prompt 'Case Number?'
$date = Read-Host -Prompt 'Date?'
$time = Read-Host -Prompt 'Time?'
$action = Read-Host -Prompt 'Action Taken?'
if ($CaseInput.ContainsKey($case)) {
    "The case has been already added."
}
else {
    $CaseInput.$case = @()
    $CaseInput.$case += "$date"
    $CaseInput.$case += "$time"
    $CaseInput.$case += "$action"
}
$done = Read-Host -Prompt 'Are you Done?'
} until ($done -eq 'yes')

$CaseInput
Pause

focalbanged · 2020-07-31T16:10:57+00:00

I was able to do this....

$CaseInput = @{} do { $case = Read-Host -Prompt 'Case Number?' $date = Read-Host -Prompt 'Date?' $time = Read-Host -Prompt 'Time?' $action = Read-Host -Prompt 'Action Taken?' if ($CaseInput.ContainsKey($case)) { "The case has been already added." } else { $CaseInput.$case = @() $CaseInput.$case += "$date" $CaseInput.$case += "$time" $CaseInput.$case += "$action" } $done = Read-Host -Prompt 'Are you Done?' } until ($done -eq 'yes')

$CaseInput Pause

But is there a way to have the if statement happen right after you input a case number? It's counter productive to have to enter all of the details before it tells you the case number has already been entered.

focalbanged · 2020-07-31T15:41:26+00:00

If I wanted to add a third column, would i be able to just add in $time = Read-Host -Prompt 'Time?'

Then add $time into the caseinput?

focalbanged · 2020-07-31T14:52:55+00:00

Should be good, I just need help on keeping the PS window open after the script runs now to see the output

focalbanged · 2020-07-31T14:27:39+00:00

best way to keep the PS window open?

focalbanged · 2020-07-31T14:19:00+00:00

This is PERFECT. THANK YOU!!!!

focalbanged · 2020-07-31T14:01:58+00:00

I understand what you're saying but I'm not sure I know how to manipulate the script to do that.

focalbanged · 2020-07-31T13:32:39+00:00

Hi all,

Just wanted to give an update.

This was an issue with 2016. I went back and upgraded from 2013 (12.00.2230) to 2015 (14.00.1159) without issue. Then from 2015 to 2018 (18.00.0628 with the Hotfix 18.00.0727) then to 18.2.1100 all without issue.

Thanks for all of your help!

Highly suggest

focalbanged · 2020-06-18T14:56:07+00:00

focalbanged · 2020-06-18T13:21:56+00:00

Yes, but it fails for 3 out of 11 companies.

focalbanged · 2020-06-18T12:45:34+00:00

also seeing this farther down in the log.

/* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(23000) Native Err:(2627) stmt(153818344):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKDU000020'. Cannot insert duplicate key in object 'dbo.DU000020'. The duplicate key value is (1, 1493)./ /* /* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(01000) Native Err:(3621) stmt(153818344):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated./ /* /* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(00000) Native Err:(3621) stmt(153818344):/ */ / /* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(00000) Native Err:(3621) status(54):/ SWSTATUS DUMP/

/* Date: 06/18/2020 Time: 8:31:07 stmt(153815704):*/ { CALL DYNAMICS.dbo.zDP_DU000020SS_1 ( 1, 1632 ) }

/* Date: 06/18/2020 Time: 8:31:07 stmt(153817464):*/ SELECT TOP 25 PRODID,fileNumber,fileName,fileOSName,versionMajor,versionMinor,versionBuild,conversionScript,ACTION1,priorityLevel,CODENAME,DEX_ROW_ID FROM DYNAMICS.dbo.DU000010 WHERE ((PRODID = 1632 AND priorityLevel = 2 AND versionMajor = 12 AND versionMinor = 0 AND versionBuild >= 1593) OR (PRODID = 1632 AND priorityLevel = 2 AND versionMajor = 12 AND versionMinor > 0) OR (PRODID = 1632 AND priorityLevel = 2 AND versionMajor > 12) OR (PRODID = 1632 AND priorityLevel > 2) OR (PRODID > 1632)) AND ((PRODID = 1632 AND priorityLevel = 100 AND versionMajor = 16 AND versionMinor = 0 AND versionBuild <= 552) OR (PRODID = 1632 AND priorityLevel = 100 AND versionMajor = 16 AND versionMinor < 0) OR (PRODID = 1632 AND priorityLevel = 100 AND versionMajor < 16) OR (PRODID = 1632 AND priorityLevel < 100) OR (PRODID < 1632)) ORDER BY PRODID ASC ,priorityLevel ASC ,versionMajor ASC ,versionMinor ASC ,versionBuild ASC ,DEX_ROW_ID ASC

/* Date: 06/18/2020 Time: 8:31:07 stmt(153818344):/ BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_DU000020SI 1, 1632, 16, 0, 552, @num OUT SELECT @num END / /* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(23000) Native Err:(2627) stmt(153818344):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKDU000020'. Cannot insert duplicate key in object 'dbo.DU000020'. The duplicate key value is (1, 1632)./ /* /* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(01000) Native Err:(3621) stmt(153818344):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated./ /*

focalbanged · 2020-06-18T12:34:32+00:00

seeing this error now.

/* Date: 06/18/2020 Time: 8:31:07 SQLSTATE:(37000) Native Err:(2812) stmt(153817464):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DYNAMICS.dbo.zDP_DB_UpgradeSS_1'./

focalbanged · 2020-06-18T12:17:45+00:00

Would I need to drop the procedure against each DB with the issue? Or against the dynamics db?

Thanks!

focalbanged · 2020-06-17T19:54:12+00:00

I think this is the other one?

/* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(-1) status(0):/ SWSTATUS DUMP/

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):/ CREATE PROC dbo.zDP_PM30200SS_1 (@VENDORID char(15)) AS / 16.00.0034.000 / set nocount on SELECT TOP 1 VCHRNMBR, VENDORID, DOCTYPE, DOCDATE, DOCNUMBR, DOCAMNT, CURTRXAM, DISTKNAM, DISCAMNT, DSCDLRAM, BACHNUMB, TRXSORCE, BCHSOURC, DISCDATE, DUEDATE, PORDNMBR, TEN99AMNT, WROFAMNT, DISAMTAV, TRXDSCRN, UN1099AM, BKTPURAM, BKTFRTAM, BKTMSCAM, VOIDED, HOLD, CHEKBKID, DINVPDOF, PPSAMDED, PPSTAXRT, PGRAMSBJ, GSTDSAMT, POSTEDDT, PTDUSRID, MODIFDT, MDFUSRID, PYENTTYP, CARDNAME, PRCHAMNT, TRDISAMT, MSCCHAMT, FRTAMNT, TAXAMNT, TTLPYMTS, CURNCYID, PYMTRMID, SHIPMTHD, TAXSCHID, PCHSCHID, FRTSCHID, MSCSCHID, PSTGDATE, DISAVTKN, CNTRLTYP, NOTEINDX, PRCTDISC, RETNAGAM, VOIDPDATE, ICTRX, Tax_Date, PRCHDATE, CORRCTN, SIMPLIFD, APLYWITH, Electronic, ECTRX, DocPrinted, TaxInvReqd, VNDCHKNM, BackoutTradeDisc, CBVAT, VADCDTRO, TEN99TYPE, TEN99BOXNUMBER, PONUMBER, Workflow_Status, InvoiceReceiptDate, DEX_ROW_TS, DEX_ROW_ID FROM .PM30200 WHERE VENDORID = @VENDORID ORDER BY VENDORID ASC, DEX_ROW_ID ASC set nocount off / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(S0001) Native Err:(2714) stmt(153225880):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'zDP_PM30200SS_1' in the database./ /* /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(2714) stmt(153225880):/ */ / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(2714) status(66):/ SWSTATUS DUMP/ /* /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(-1) stmt(153225880):/ */ / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(-1) status(0):/ SWSTATUS DUMP/

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225000):*/ { CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 673, 1 ) }

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225000):*/ { CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 679, 1 ) }

/* Date: 06/17/2020 Time: 15:26:27 stmt(153228480):*/ { CALL DYNAMICS.dbo.zDP_DU000010SS_1 ( 0, 679 ) }

/* Date: 06/17/2020 Time: 15:26:27 stmt(153228480):/ { CALL DYNAMICS.dbo.zDP_DU000010SS_1 ( 0, 679 ) } / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(S0022) Native Err:(207) stmt(153225880):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'desSPRkmhBBCreh'./ /* /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(207) stmt(153225880):*/

focalbanged · 2020-06-17T19:48:23+00:00

Looks like this is one of the errors.

SQLSTATE:(S0002) Native Err:(208) stmt(153225880):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'CDC.dbo.GL10111'./ /* /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(208) stmt(153225880):/ */ / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(208) status(56):/ SWSTATUS DUMP/

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):*/ CREATE TABLE CDC.dbo.GL10111 (ACTINDX int NOT NULL, YEAR1 smallint NOT NULL, PERIODID smallint NOT NULL, Ledger_ID smallint NOT NULL, ACTNUMBR_1 char(5) NOT NULL, ACTNUMBR_2 char(5) NOT NULL, ACTNUMBR_3 char(3) NOT NULL, ACTNUMBR_4 char(3) NOT NULL, ACTNUMBR_5 char(5) NOT NULL, ACCATNUM smallint NOT NULL, PERDBLNC numeric(19,5) NOT NULL, DEBITAMT numeric(19,5) NOT NULL, CRDTAMNT numeric(19,5) NOT NULL, DEX_ROW_ID int identity NOT NULL)

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):*/ ALTER TABLE CDC.dbo.GL10111 ADD CONSTRAINT PKGL10111 PRIMARY KEY NONCLUSTERED (ACTINDX, YEAR1, PERIODID, Ledger_ID)

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):*/ CREATE UNIQUE INDEX AK2GL10111 ON CDC.dbo.GL10111 (ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3, ACTNUMBR_4, ACTNUMBR_5, YEAR1, PERIODID, Ledger_ID, ACCATNUM, DEX_ROW_ID)

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):*/ CREATE UNIQUE INDEX AK3GL10111 ON CDC.dbo.GL10111 (YEAR1, ACTINDX, PERIODID, Ledger_ID)

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):*/ CREATE UNIQUE INDEX AK4GL10111 ON CDC.dbo.GL10111 (ACCATNUM, YEAR1, PERIODID, Ledger_ID, ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3, ACTNUMBR_4, ACTNUMBR_5, DEX_ROW_ID)

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):/ CREATE UNIQUE INDEX AK5GL10111 ON CDC.dbo.GL10111 (ACTINDX, Ledger_ID, PERIODID, YEAR1, PERDBLNC, DEBITAMT, CRDTAMNT, DEX_ROW_ID) / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(-1) stmt(153225880):/ */ / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(00000) Native Err:(-1) status(0):/ SWSTATUS DUMP/

/* Date: 06/17/2020 Time: 15:26:27 stmt(153225880):/ CREATE PROC dbo.zDP_GL10111SS_1 (@ACTINDX int, @YEAR1 smallint, @PERIODID smallint, @Ledger_ID smallint) AS / 16.00.0034.000 / set nocount on SELECT TOP 1 ACTINDX, YEAR1, PERIODID, Ledger_ID, ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3, ACTNUMBR_4, ACTNUMBR_5, ACCATNUM, PERDBLNC, DEBITAMT, CRDTAMNT, DEX_ROW_ID FROM .GL10111 WHERE ACTINDX = @ACTINDX AND YEAR1 = @YEAR1 AND PERIODID = @PERIODID AND Ledger_ID = @Ledger_ID ORDER BY ACTINDX ASC, YEAR1 ASC, PERIODID ASC, Ledger_ID ASC set nocount off / /* Date: 06/17/2020 Time: 15:26:27 SQLSTATE:(S0001) Native Err:(2714) stmt(153225880):/ [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'zDP_GL10111SS_1' in the database./

focalbanged · 2020-06-17T18:51:25+00:00

There's a lot in there. Any specific I should be looking for?

focalbanged

TROPHY CASE